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