dbaccess/source/ui/dlg/UserAdmin.cxx

   1 /*************************************************************************
   2  *
   3  * DO NOT ALTER OR REMOVE COPYRIGHT NOTICES OR THIS FILE HEADER.
   4  *
   5  * Copyright 2008 by Sun Microsystems, Inc.
   6  *
   7  * OpenOffice.org - a multi-platform office productivity suite
   8  *
   9  * $RCSfile: UserAdmin.cxx,v $
  10  * $Revision: 1.20 $
  11  *
  12  * This file is part of OpenOffice.org.
  13  *
  14  * OpenOffice.org is free software: you can redistribute it and/or modify
  15  * it under the terms of the GNU Lesser General Public License version 3
  16  * only, as published by the Free Software Foundation.
  17  *
  18  * OpenOffice.org is distributed in the hope that it will be useful,
  19  * but WITHOUT ANY WARRANTY; without even the implied warranty of
  20  * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
  21  * GNU Lesser General Public License version 3 for more details
  22  * (a copy is included in the LICENSE file that accompanied this code).
  23  *
  24  * You should have received a copy of the GNU Lesser General Public License
  25  * version 3 along with OpenOffice.org.  If not, see
  26  * <http://www.openoffice.org/license.html>
  27  * for a copy of the LGPLv3 License.
  28  *
  29  ************************************************************************/
  30
  31 // MARKER(update_precomp.py): autogen include statement, do not remove
  32 #include "precompiled_dbaccess.hxx"
  33
  34 #ifndef DBAUI_USERADMIN_HXX
  35 #include "UserAdmin.hxx"
  36 #endif
  37 #ifndef DBAUI_USERADMIN_HRC
  38 #include "UserAdmin.hrc"
  39 #endif
  40 #ifndef DBAUI_TOOLS_HXX
  41 #include "UITools.hxx"
  42 #endif
  43 #ifndef _DBU_DLG_HRC_
  44 #include "dbu_dlg.hrc"
  45 #endif
  46 #ifndef _COMPHELPER_TYPES_HXX_
  47 #include <comphelper/types.hxx>
  48 #endif
  49 #ifndef _COM_SUN_STAR_SDBC_XDATABASEMETADATA_HPP_
  50 #include <com/sun/star/sdbc/XDatabaseMetaData.hpp>
  51 #endif
  52 #ifndef _COM_SUN_STAR_SDBCX_XDATADEFINITIONSUPPLIER_HPP_
  53 #include <com/sun/star/sdbcx/XDataDefinitionSupplier.hpp>
  54 #endif
  55 #ifndef _COM_SUN_STAR_SDBCX_XUSERSSUPPLIER_HPP_
  56 #include <com/sun/star/sdbcx/XUsersSupplier.hpp>
  57 #endif
  58 #ifndef _COM_SUN_STAR_SDBCX_XDROP_HPP_
  59 #include <com/sun/star/sdbcx/XDrop.hpp>
  60 #endif
  61 #ifndef _UCBHELPER_INTERATIONREQUEST_HXX
  62 #include <ucbhelper/interactionrequest.hxx>
  63 #endif
  64 #ifndef _UCBHELPER_SIMPLEAUTHENTICATIONREQUEST_HXX
  65 #include <ucbhelper/simpleauthenticationrequest.hxx>
  66 #endif
  67 #ifndef _COM_SUN_STAR_SDBCX_XDATADESCRIPTORFACTORY_HPP_
  68 #include <com/sun/star/sdbcx/XDataDescriptorFactory.hpp>
  69 #endif
  70 #ifndef _COM_SUN_STAR_BEANS_XPROPERTYSET_HPP_
  71 #include <com/sun/star/beans/XPropertySet.hpp>
  72 #endif
  73 #ifndef _COM_SUN_STAR_SDBCX_XUSER_HPP_
  74 #include <com/sun/star/sdbcx/XUser.hpp>
  75 #endif
  76 #ifndef _COM_SUN_STAR_SDBCX_XAPPEND_HPP_
  77 #include <com/sun/star/sdbcx/XAppend.hpp>
  78 #endif
  79 #ifndef DBACCESS_SHARED_DBUSTRINGS_HRC
  80 #include "dbustrings.hrc"
  81 #endif
  82 #ifndef _TOOLS_DEBUG_HXX
  83 #include <tools/debug.hxx>
  84 #endif
  85 #ifndef _DBAUI_DBADMIN_HXX_
  86 #include "dbadmin.hxx"
  87 #endif
  88 #ifndef _DBAUI_MODULE_DBU_HXX_
  89 #include "moduledbu.hxx"
  90 #endif
  91 #ifndef _SV_MSGBOX_HXX
  92 #include <vcl/msgbox.hxx>
  93 #endif
  94 #ifndef _SFX_PASSWD_HXX
  95 #include <sfx2/passwd.hxx>
  96 #endif
  97
  98 using namespace ::com::sun::star::container;
  99 using namespace ::com::sun::star::beans;
 100 using namespace ::com::sun::star::sdbcx;
 101 using namespace ::com::sun::star::sdbc;
 102 using namespace ::com::sun::star::uno;
 103 using namespace ::com::sun::star::task;
 104 using namespace dbaui;
 105 using namespace ucbhelper;
 106 using namespace comphelper;
 107
 108
 109 class OPasswordDialog : public ModalDialog
 110 {
 111     FixedLine           aFLUser;
 112     FixedText           aFTOldPassword;
 113     Edit                        aEDOldPassword;
 114     FixedText           aFTPassword;
 115     Edit                        aEDPassword;
 116     FixedText           aFTPasswordRepeat;
 117     Edit                        aEDPasswordRepeat;
 118     OKButton            aOKBtn;
 119     CancelButton        aCancelBtn;
 120     HelpButton          aHelpBtn;
 121
 122
 123     DECL_LINK( OKHdl_Impl, OKButton * );
 124     DECL_LINK( ModifiedHdl, Edit * );
 125
 126 public:
 127     OPasswordDialog( Window* pParent,const String& _sUserName);
 128
 129     String                      GetOldPassword() const { return aEDOldPassword.GetText(); }
 130     String                      GetNewPassword() const { return aEDPassword.GetText(); }
 131 };
 132
 133 OPasswordDialog::OPasswordDialog(Window* _pParent,const String& _sUserName) :
 134
 135     ModalDialog( _pParent, ModuleRes( DLG_PASSWORD) ),
 136
 137     aFLUser                             ( this, ModuleRes( FL_USER ) ),
 138     aFTOldPassword              ( this, ModuleRes( FT_OLDPASSWORD ) ),
 139     aEDOldPassword              ( this, ModuleRes( ED_OLDPASSWORD ) ),
 140     aFTPassword                 ( this, ModuleRes( FT_PASSWORD ) ),
 141     aEDPassword                 ( this, ModuleRes( ED_PASSWORD ) ),
 142     aFTPasswordRepeat   ( this, ModuleRes( FT_PASSWORD_REPEAT ) ),
 143     aEDPasswordRepeat   ( this, ModuleRes( ED_PASSWORD_REPEAT ) ),
 144     aOKBtn                              ( this, ModuleRes( BTN_PASSWORD_OK ) ),
 145     aCancelBtn                  ( this, ModuleRes( BTN_PASSWORD_CANCEL ) ),
 146     aHelpBtn                    ( this, ModuleRes( BTN_PASSWORD_HELP ) )
 147 {
 148     // hide until a help is avalable
 149     aHelpBtn.Hide();
 150
 151     FreeResource();
 152     String sUser = aFLUser.GetText();
 153     sUser.SearchAndReplaceAscii("$name$:  $",_sUserName);
 154     aFLUser.SetText(sUser);
 155     aOKBtn.Disable();
 156
 157     aOKBtn.SetClickHdl( LINK( this, OPasswordDialog, OKHdl_Impl ) );
 158     aEDOldPassword.SetModifyHdl( LINK( this, OPasswordDialog, ModifiedHdl ) );
 159 }
 160 // -----------------------------------------------------------------------------
 161 IMPL_LINK( OPasswordDialog, OKHdl_Impl, OKButton *, EMPTYARG )
 162 {
 163     if( aEDPassword.GetText() == aEDPasswordRepeat.GetText() )
 164         EndDialog( RET_OK );
 165     else
 166     {
 167         String aErrorMsg( ModuleRes( STR_ERROR_PASSWORDS_NOT_IDENTICAL));
 168         ErrorBox aErrorBox( this, WB_OK, aErrorMsg );
 169         aErrorBox.Execute();
 170         aEDPassword.SetText( String() );
 171         aEDPasswordRepeat.SetText( String() );
 172         aEDPassword.GrabFocus();
 173     }
 174     return 0;
 175 }
 176 // -----------------------------------------------------------------------------
 177 IMPL_LINK( OPasswordDialog, ModifiedHdl, Edit *, pEdit )
 178 {
 179     aOKBtn.Enable(pEdit->GetText().Len() != 0);
 180     return 0;
 181 }
 182
 183 DBG_NAME(OUserAdmin);
 184 //================================================================================
 185 // OUserAdmin
 186 //================================================================================
 187 OUserAdmin::OUserAdmin(Window* pParent,const SfxItemSet& _rAttrSet)
 188     : OGenericAdministrationPage( pParent, ModuleRes(TAB_PAGE_USERADMIN), _rAttrSet)
 189     ,m_FL_USER(                 this , ModuleRes(FL_USER))
 190     ,m_FT_USER(                 this , ModuleRes(FT_USER))
 191     ,m_LB_USER(                 this , ModuleRes(LB_USER))
 192     ,m_PB_NEWUSER(              this , ModuleRes(PB_NEWUSER))
 193     ,m_PB_CHANGEPWD(    this , ModuleRes(PB_CHANGEPWD))
 194     ,m_PB_DELETEUSER(   this , ModuleRes(PB_DELETEUSER))
 195     ,m_FL_TABLE_GRANTS( this , ModuleRes(FL_TABLE_GRANTS))
 196     ,m_TableCtrl(               this , ModuleRes(CTRL_TABLE_GRANTS))
 197 {
 198     DBG_CTOR(OUserAdmin,NULL);
 199     m_LB_USER.SetSelectHdl(LINK(this, OUserAdmin, ListDblClickHdl));
 200
 201     m_PB_NEWUSER.SetClickHdl(LINK(this, OUserAdmin, UserHdl));
 202     m_PB_CHANGEPWD.SetClickHdl(LINK(this, OUserAdmin, UserHdl));
 203     m_PB_DELETEUSER.SetClickHdl(LINK(this, OUserAdmin, UserHdl));
 204
 205     FreeResource();
 206 }
 207 // -----------------------------------------------------------------------
 208 OUserAdmin::~OUserAdmin()
 209 {
 210     DBG_DTOR(OUserAdmin,NULL);
 211     m_xConnection = NULL;
 212 }
 213 // -----------------------------------------------------------------------
 214 void OUserAdmin::FillUserNames()
 215 {
 216     if(m_xConnection.is())
 217     {
 218         m_LB_USER.Clear();
 219
 220         Reference<XDatabaseMetaData> xMetaData = m_xConnection->getMetaData();
 221
 222         if ( xMetaData.is() )
 223         {
 224             m_UserName = xMetaData->getUserName();
 225
 226             // first we need the users
 227             if ( m_xUsers.is() )
 228             {
 229                 m_LB_USER.Clear();
 230
 231                 m_aUserNames = m_xUsers->getElementNames();
 232                 const ::rtl::OUString* pBegin = m_aUserNames.getConstArray();
 233                 const ::rtl::OUString* pEnd       = pBegin + m_aUserNames.getLength();
 234                 ::rtl::OUString sUserName = m_UserName;
 235                 for(;pBegin != pEnd;++pBegin)
 236                     m_LB_USER.InsertEntry(*pBegin);
 237
 238                 m_LB_USER.SelectEntryPos(0);
 239                 if(m_xUsers->hasByName(m_UserName))
 240                 {
 241                     Reference<XAuthorizable> xAuth;
 242                     m_xUsers->getByName(m_UserName) >>= xAuth;
 243                     m_TableCtrl.setGrantUser(xAuth);
 244                 }
 245
 246                 m_TableCtrl.setUserName(GetUser());
 247                 m_TableCtrl.Init();
 248             }
 249         }
 250     }
 251
 252     Reference<XAppend> xAppend(m_xUsers,UNO_QUERY);
 253     m_PB_NEWUSER.Enable(xAppend.is());
 254     Reference<XDrop> xDrop(m_xUsers,UNO_QUERY);
 255     m_PB_DELETEUSER.Enable(xDrop.is());
 256
 257     m_PB_CHANGEPWD.Enable(m_xUsers.is());
 258     m_TableCtrl.Enable(m_xUsers.is());
 259
 260 }
 261 // -----------------------------------------------------------------------
 262 SfxTabPage*     OUserAdmin::Create( Window* pParent, const SfxItemSet& _rAttrSet )
 263 {
 264     return ( new OUserAdmin( pParent, _rAttrSet ) );
 265 }
 266 // -----------------------------------------------------------------------
 267 IMPL_LINK( OUserAdmin, UserHdl, PushButton *, pButton )
 268 {
 269     try
 270     {
 271         if(pButton == &m_PB_NEWUSER)
 272         {
 273             SfxPasswordDialog aPwdDlg(this);
 274             aPwdDlg.ShowExtras(SHOWEXTRAS_ALL);
 275             if(aPwdDlg.Execute())
 276             {
 277                 Reference<XDataDescriptorFactory> xUserFactory(m_xUsers,UNO_QUERY);
 278                 Reference<XPropertySet> xNewUser = xUserFactory->createDataDescriptor();
 279                 if(xNewUser.is())
 280                 {
 281                     xNewUser->setPropertyValue(PROPERTY_NAME,makeAny(rtl::OUString(aPwdDlg.GetUser())));
 282                     xNewUser->setPropertyValue(PROPERTY_PASSWORD,makeAny(rtl::OUString(aPwdDlg.GetPassword())));
 283                     Reference<XAppend> xAppend(m_xUsers,UNO_QUERY);
 284                     if(xAppend.is())
 285                         xAppend->appendByDescriptor(xNewUser);
 286                 }
 287             }
 288         }
 289         else if(pButton == &m_PB_CHANGEPWD)
 290         {
 291             String sName = GetUser();
 292
 293             if(m_xUsers->hasByName(sName))
 294             {
 295                 Reference<XUser> xUser;
 296                 m_xUsers->getByName(sName) >>= xUser;
 297                 if(xUser.is())
 298                 {
 299                     ::rtl::OUString sNewPassword,sOldPassword;
 300                     OPasswordDialog aDlg(this,sName);
 301                     if(aDlg.Execute() == RET_OK)
 302                     {
 303                         sNewPassword = aDlg.GetNewPassword();
 304                         sOldPassword = aDlg.GetOldPassword();
 305
 306                         if(sNewPassword.getLength())
 307                             xUser->changePassword(sOldPassword,sNewPassword);
 308                     }
 309                 }
 310             }
 311         }
 312         else
 313         {// delete user
 314             if(m_xUsers.is() && m_xUsers->hasByName(GetUser()))
 315             {
 316                 Reference<XDrop> xDrop(m_xUsers,UNO_QUERY);
 317                 if(xDrop.is())
 318                 {
 319                     QueryBox aQry(this, ModuleRes(QUERY_USERADMIN_DELETE_USER));
 320                     if(aQry.Execute() == RET_YES)
 321                         xDrop->dropByName(GetUser());
 322                 }
 323             }
 324         }
 325         FillUserNames();
 326     }
 327     catch(SQLException& e)
 328     {
 329         ::dbaui::showError(::dbtools::SQLExceptionInfo(e),this,m_xORB);
 330         return 0;
 331     }
 332     catch(Exception& )
 333     {
 334         return 0;
 335     }
 336
 337     return 0;
 338 }
 339 // -----------------------------------------------------------------------
 340 IMPL_LINK( OUserAdmin, ListDblClickHdl, ListBox *, /*pListBox*/ )
 341 {
 342     m_TableCtrl.setUserName(GetUser());
 343     m_TableCtrl.UpdateTables();
 344     m_TableCtrl.DeactivateCell();
 345     m_TableCtrl.ActivateCell(m_TableCtrl.GetCurRow(),m_TableCtrl.GetCurColumnId());
 346     return 0;
 347 }
 348
 349 // -----------------------------------------------------------------------
 350 String OUserAdmin::GetUser()
 351 {
 352     return m_LB_USER.GetSelectEntry();
 353 }
 354 // -----------------------------------------------------------------------------
 355 void OUserAdmin::fillControls(::std::vector< ISaveValueWrapper* >& /*_rControlList*/)
 356 {
 357 }
 358 // -----------------------------------------------------------------------
 359 void OUserAdmin::fillWindows(::std::vector< ISaveValueWrapper* >& /*_rControlList*/)
 360 {
 361 }
 362 // -----------------------------------------------------------------------------
 363 void OUserAdmin::implInitControls(const SfxItemSet& _rSet, sal_Bool _bSaveValue)
 364 {
 365     m_TableCtrl.setORB(m_xORB);
 366     try
 367     {
 368         if ( !m_xConnection.is() && m_pAdminDialog )
 369         {
 370             m_xConnection = m_pAdminDialog->createConnection().first;
 371             Reference< XTablesSupplier > xTablesSup(m_xConnection,UNO_QUERY);
 372             Reference<XUsersSupplier> xUsersSup(xTablesSup,UNO_QUERY);
 373             if ( !xUsersSup.is() )
 374             {
 375                 Reference< XDataDefinitionSupplier > xDriver(m_pAdminDialog->getDriver(),UNO_QUERY);
 376                 if ( xDriver.is() )
 377                 {
 378                     xUsersSup.set(xDriver->getDataDefinitionByConnection(m_xConnection),UNO_QUERY);
 379                     xTablesSup.set(xUsersSup,UNO_QUERY);
 380                 }
 381             }
 382             if ( xUsersSup.is() )
 383             {
 384                 m_TableCtrl.setTablesSupplier(xTablesSup);
 385                 m_xUsers = xUsersSup->getUsers();
 386             }
 387         }
 388         FillUserNames();
 389     }
 390     catch(SQLException& e)
 391     {
 392         ::dbaui::showError(::dbtools::SQLExceptionInfo(e),this,m_xORB);
 393     }
 394
 395     OGenericAdministrationPage::implInitControls(_rSet, _bSaveValue);
 396 }