xref: /AOO41X/main/dbaccess/source/ui/dlg/UserAdmin.cxx (revision 96de54900b79e13b861fbc62cbf36018b54e21b7)

/**************************************************************
 *
 * Licensed to the Apache Software Foundation (ASF) under one
 * or more contributor license agreements.  See the NOTICE file
 * distributed with this work for additional information
 * regarding copyright ownership.  The ASF licenses this file
 * to you under the Apache License, Version 2.0 (the
 * "License"); you may not use this file except in compliance
 * with the License.  You may obtain a copy of the License at
 *
 *   http://www.apache.org/licenses/LICENSE-2.0
 *
 * Unless required by applicable law or agreed to in writing,
 * software distributed under the License is distributed on an
 * "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY
 * KIND, either express or implied.  See the License for the
 * specific language governing permissions and limitations
 * under the License.
 *
 *************************************************************/



// MARKER(update_precomp.py): autogen include statement, do not remove
#include "precompiled_dbaccess.hxx"

#ifndef DBAUI_USERADMIN_HXX
#include "UserAdmin.hxx"
#endif
#ifndef DBAUI_USERADMIN_HRC
#include "UserAdmin.hrc"
#endif
#ifndef DBAUI_TOOLS_HXX
#include "UITools.hxx"
#endif
#ifndef _DBU_DLG_HRC_
#include "dbu_dlg.hrc"
#endif
#ifndef _COMPHELPER_TYPES_HXX_
#include <comphelper/types.hxx>
#endif
#ifndef _COM_SUN_STAR_SDBC_XDATABASEMETADATA_HPP_
#include <com/sun/star/sdbc/XDatabaseMetaData.hpp>
#endif
#ifndef _COM_SUN_STAR_SDBCX_XDATADEFINITIONSUPPLIER_HPP_
#include <com/sun/star/sdbcx/XDataDefinitionSupplier.hpp>
#endif
#ifndef _COM_SUN_STAR_SDBCX_XUSERSSUPPLIER_HPP_
#include <com/sun/star/sdbcx/XUsersSupplier.hpp>
#endif
#ifndef _COM_SUN_STAR_SDBCX_XDROP_HPP_
#include <com/sun/star/sdbcx/XDrop.hpp>
#endif
#ifndef _UCBHELPER_INTERATIONREQUEST_HXX
#include <ucbhelper/interactionrequest.hxx>
#endif
#ifndef _UCBHELPER_SIMPLEAUTHENTICATIONREQUEST_HXX
#include <ucbhelper/simpleauthenticationrequest.hxx>
#endif
#ifndef _COM_SUN_STAR_SDBCX_XDATADESCRIPTORFACTORY_HPP_
#include <com/sun/star/sdbcx/XDataDescriptorFactory.hpp>
#endif
#ifndef _COM_SUN_STAR_BEANS_XPROPERTYSET_HPP_
#include <com/sun/star/beans/XPropertySet.hpp>
#endif
#ifndef _COM_SUN_STAR_SDBCX_XUSER_HPP_
#include <com/sun/star/sdbcx/XUser.hpp>
#endif
#ifndef _COM_SUN_STAR_SDBCX_XAPPEND_HPP_
#include <com/sun/star/sdbcx/XAppend.hpp>
#endif
#ifndef DBACCESS_SHARED_DBUSTRINGS_HRC
#include "dbustrings.hrc"
#endif
#ifndef _TOOLS_DEBUG_HXX
#include <tools/debug.hxx>
#endif
#ifndef _DBAUI_DBADMIN_HXX_
#include "dbadmin.hxx"
#endif
#ifndef _DBAUI_MODULE_DBU_HXX_
#include "moduledbu.hxx"
#endif
#ifndef _SV_MSGBOX_HXX
#include <vcl/msgbox.hxx>
#endif
#ifndef _SFX_PASSWD_HXX
#include <sfx2/passwd.hxx>
#endif

using namespace ::com::sun::star::container;
using namespace ::com::sun::star::beans;
using namespace ::com::sun::star::sdbcx;
using namespace ::com::sun::star::sdbc;
using namespace ::com::sun::star::uno;
using namespace ::com::sun::star::task;
using namespace dbaui;
using namespace ucbhelper;
using namespace comphelper;


class OPasswordDialog : public ModalDialog
{
	FixedLine		aFLUser;
	FixedText		aFTOldPassword;
	Edit			aEDOldPassword;
	FixedText		aFTPassword;
	Edit			aEDPassword;
	FixedText		aFTPasswordRepeat;
	Edit			aEDPasswordRepeat;
	OKButton		aOKBtn;
	CancelButton	aCancelBtn;
	HelpButton		aHelpBtn;


	DECL_LINK( OKHdl_Impl, OKButton * );
	DECL_LINK( ModifiedHdl, Edit * );

public:
	OPasswordDialog( Window* pParent,const String& _sUserName);

	String			GetOldPassword() const { return aEDOldPassword.GetText(); }
	String			GetNewPassword() const { return aEDPassword.GetText(); }
};

OPasswordDialog::OPasswordDialog(Window* _pParent,const String& _sUserName) :

	ModalDialog( _pParent, ModuleRes( DLG_PASSWORD) ),

	aFLUser				( this, ModuleRes( FL_USER ) ),
	aFTOldPassword		( this, ModuleRes( FT_OLDPASSWORD ) ),
	aEDOldPassword		( this, ModuleRes( ED_OLDPASSWORD ) ),
	aFTPassword			( this, ModuleRes( FT_PASSWORD ) ),
	aEDPassword			( this, ModuleRes( ED_PASSWORD ) ),
	aFTPasswordRepeat	( this, ModuleRes( FT_PASSWORD_REPEAT ) ),
	aEDPasswordRepeat	( this, ModuleRes( ED_PASSWORD_REPEAT ) ),
	aOKBtn				( this, ModuleRes( BTN_PASSWORD_OK ) ),
	aCancelBtn			( this, ModuleRes( BTN_PASSWORD_CANCEL ) ),
	aHelpBtn			( this, ModuleRes( BTN_PASSWORD_HELP ) )
{
	// hide until a help is avalable
	aHelpBtn.Hide();

	FreeResource();
	String sUser = aFLUser.GetText();
	sUser.SearchAndReplaceAscii("$name$:  $",_sUserName);
	aFLUser.SetText(sUser);
	aOKBtn.Disable();

	aOKBtn.SetClickHdl( LINK( this, OPasswordDialog, OKHdl_Impl ) );
	aEDOldPassword.SetModifyHdl( LINK( this, OPasswordDialog, ModifiedHdl ) );
}
// -----------------------------------------------------------------------------
IMPL_LINK( OPasswordDialog, OKHdl_Impl, OKButton *, EMPTYARG )
{
	if( aEDPassword.GetText() == aEDPasswordRepeat.GetText() )
		EndDialog( RET_OK );
	else
	{
		String aErrorMsg( ModuleRes( STR_ERROR_PASSWORDS_NOT_IDENTICAL));
		ErrorBox aErrorBox( this, WB_OK, aErrorMsg );
		aErrorBox.Execute();
		aEDPassword.SetText( String() );
		aEDPasswordRepeat.SetText( String() );
		aEDPassword.GrabFocus();
	}
	return 0;
}
// -----------------------------------------------------------------------------
IMPL_LINK( OPasswordDialog, ModifiedHdl, Edit *, pEdit )
{
	aOKBtn.Enable(pEdit->GetText().Len() != 0);
	return 0;
}

DBG_NAME(OUserAdmin);
//================================================================================
// OUserAdmin
//================================================================================
OUserAdmin::OUserAdmin(Window* pParent,const SfxItemSet& _rAttrSet)
	: OGenericAdministrationPage( pParent, ModuleRes(TAB_PAGE_USERADMIN), _rAttrSet)
	,m_FL_USER(			this , ModuleRes(FL_USER))
	,m_FT_USER(			this , ModuleRes(FT_USER))
	,m_LB_USER(			this , ModuleRes(LB_USER))
	,m_PB_NEWUSER(		this , ModuleRes(PB_NEWUSER))
	,m_PB_CHANGEPWD(	this , ModuleRes(PB_CHANGEPWD))
	,m_PB_DELETEUSER(	this , ModuleRes(PB_DELETEUSER))
	,m_FL_TABLE_GRANTS( this , ModuleRes(FL_TABLE_GRANTS))
	,m_TableCtrl(		this , ModuleRes(CTRL_TABLE_GRANTS))
{
	DBG_CTOR(OUserAdmin,NULL);
	m_LB_USER.SetSelectHdl(LINK(this, OUserAdmin, ListDblClickHdl));

	m_PB_NEWUSER.SetClickHdl(LINK(this, OUserAdmin, UserHdl));
	m_PB_CHANGEPWD.SetClickHdl(LINK(this, OUserAdmin, UserHdl));
	m_PB_DELETEUSER.SetClickHdl(LINK(this, OUserAdmin, UserHdl));

	FreeResource();
}
// -----------------------------------------------------------------------
OUserAdmin::~OUserAdmin()
{
	DBG_DTOR(OUserAdmin,NULL);
	m_xConnection = NULL;
}
// -----------------------------------------------------------------------
void OUserAdmin::FillUserNames()
{
	if(m_xConnection.is())
	{
		m_LB_USER.Clear();

		Reference<XDatabaseMetaData> xMetaData = m_xConnection->getMetaData();

		if ( xMetaData.is() )
		{
			m_UserName = xMetaData->getUserName();

			// first we need the users
			if ( m_xUsers.is() )
			{
				m_LB_USER.Clear();

				m_aUserNames = m_xUsers->getElementNames();
				const ::rtl::OUString* pBegin = m_aUserNames.getConstArray();
				const ::rtl::OUString* pEnd	  = pBegin + m_aUserNames.getLength();
				::rtl::OUString sUserName = m_UserName;
				for(;pBegin != pEnd;++pBegin)
					m_LB_USER.InsertEntry(*pBegin);

				m_LB_USER.SelectEntryPos(0);
				if(m_xUsers->hasByName(m_UserName))
				{
					Reference<XAuthorizable> xAuth;
					m_xUsers->getByName(m_UserName) >>= xAuth;
					m_TableCtrl.setGrantUser(xAuth);
				}

				m_TableCtrl.setUserName(GetUser());
				m_TableCtrl.Init();
			}
		}
	}

	Reference<XAppend> xAppend(m_xUsers,UNO_QUERY);
	m_PB_NEWUSER.Enable(xAppend.is());
	Reference<XDrop> xDrop(m_xUsers,UNO_QUERY);
	m_PB_DELETEUSER.Enable(xDrop.is());

	m_PB_CHANGEPWD.Enable(m_xUsers.is());
	m_TableCtrl.Enable(m_xUsers.is());

}
// -----------------------------------------------------------------------
SfxTabPage*	OUserAdmin::Create( Window* pParent, const SfxItemSet& _rAttrSet )
{
	return ( new OUserAdmin( pParent, _rAttrSet ) );
}
// -----------------------------------------------------------------------
IMPL_LINK( OUserAdmin, UserHdl, PushButton *, pButton )
{
	try
	{
		if(pButton == &m_PB_NEWUSER)
		{
			SfxPasswordDialog aPwdDlg(this);
			aPwdDlg.ShowExtras(SHOWEXTRAS_ALL);
			if(aPwdDlg.Execute())
			{
				Reference<XDataDescriptorFactory> xUserFactory(m_xUsers,UNO_QUERY);
				Reference<XPropertySet> xNewUser = xUserFactory->createDataDescriptor();
				if(xNewUser.is())
				{
					xNewUser->setPropertyValue(PROPERTY_NAME,makeAny(rtl::OUString(aPwdDlg.GetUser())));
					xNewUser->setPropertyValue(PROPERTY_PASSWORD,makeAny(rtl::OUString(aPwdDlg.GetPassword())));
					Reference<XAppend> xAppend(m_xUsers,UNO_QUERY);
					if(xAppend.is())
						xAppend->appendByDescriptor(xNewUser);
				}
			}
		}
		else if(pButton == &m_PB_CHANGEPWD)
		{
			String sName = GetUser();

			if(m_xUsers->hasByName(sName))
			{
				Reference<XUser> xUser;
				m_xUsers->getByName(sName) >>= xUser;
				if(xUser.is())
				{
					::rtl::OUString sNewPassword,sOldPassword;
					OPasswordDialog aDlg(this,sName);
					if(aDlg.Execute() == RET_OK)
					{
						sNewPassword = aDlg.GetNewPassword();
						sOldPassword = aDlg.GetOldPassword();

						if(sNewPassword.getLength())
							xUser->changePassword(sOldPassword,sNewPassword);
					}
				}
			}
		}
		else
		{// delete user
			if(m_xUsers.is() && m_xUsers->hasByName(GetUser()))
			{
				Reference<XDrop> xDrop(m_xUsers,UNO_QUERY);
				if(xDrop.is())
				{
					QueryBox aQry(this, ModuleRes(QUERY_USERADMIN_DELETE_USER));
					if(aQry.Execute() == RET_YES)
						xDrop->dropByName(GetUser());
				}
			}
		}
		FillUserNames();
	}
	catch(SQLException& e)
	{
		::dbaui::showError(::dbtools::SQLExceptionInfo(e),this,m_xORB);
		return 0;
	}
	catch(Exception& )
	{
		return 0;
	}

	return 0;
}
// -----------------------------------------------------------------------
IMPL_LINK( OUserAdmin, ListDblClickHdl, ListBox *, /*pListBox*/ )
{
	m_TableCtrl.setUserName(GetUser());
	m_TableCtrl.UpdateTables();
	m_TableCtrl.DeactivateCell();
	m_TableCtrl.ActivateCell(m_TableCtrl.GetCurRow(),m_TableCtrl.GetCurColumnId());
	return 0;
}

// -----------------------------------------------------------------------
String OUserAdmin::GetUser()
{
	return m_LB_USER.GetSelectEntry();
}
// -----------------------------------------------------------------------------
void OUserAdmin::fillControls(::std::vector< ISaveValueWrapper* >& /*_rControlList*/)
{
}
// -----------------------------------------------------------------------
void OUserAdmin::fillWindows(::std::vector< ISaveValueWrapper* >& /*_rControlList*/)
{
}
// -----------------------------------------------------------------------------
void OUserAdmin::implInitControls(const SfxItemSet& _rSet, sal_Bool _bSaveValue)
{
	m_TableCtrl.setORB(m_xORB);
	try
	{
		if ( !m_xConnection.is() && m_pAdminDialog )
		{
			m_xConnection = m_pAdminDialog->createConnection().first;
			Reference< XTablesSupplier > xTablesSup(m_xConnection,UNO_QUERY);
			Reference<XUsersSupplier> xUsersSup(xTablesSup,UNO_QUERY);
			if ( !xUsersSup.is() )
			{
				Reference< XDataDefinitionSupplier > xDriver(m_pAdminDialog->getDriver(),UNO_QUERY);
				if ( xDriver.is() )
				{
					xUsersSup.set(xDriver->getDataDefinitionByConnection(m_xConnection),UNO_QUERY);
					xTablesSup.set(xUsersSup,UNO_QUERY);
				}
			}
			if ( xUsersSup.is() )
			{
				m_TableCtrl.setTablesSupplier(xTablesSup);
				m_xUsers = xUsersSup->getUsers();
			}
		}
		FillUserNames();
	}
	catch(SQLException& e)
	{
		::dbaui::showError(::dbtools::SQLExceptionInfo(e),this,m_xORB);
	}

	OGenericAdministrationPage::implInitControls(_rSet, _bSaveValue);
}