1*cdf0e10cSrcweir /*************************************************************************
2*cdf0e10cSrcweir  *
3*cdf0e10cSrcweir  * DO NOT ALTER OR REMOVE COPYRIGHT NOTICES OR THIS FILE HEADER.
4*cdf0e10cSrcweir  *
5*cdf0e10cSrcweir  * Copyright 2000, 2010 Oracle and/or its affiliates.
6*cdf0e10cSrcweir  *
7*cdf0e10cSrcweir  * OpenOffice.org - a multi-platform office productivity suite
8*cdf0e10cSrcweir  *
9*cdf0e10cSrcweir  * This file is part of OpenOffice.org.
10*cdf0e10cSrcweir  *
11*cdf0e10cSrcweir  * OpenOffice.org is free software: you can redistribute it and/or modify
12*cdf0e10cSrcweir  * it under the terms of the GNU Lesser General Public License version 3
13*cdf0e10cSrcweir  * only, as published by the Free Software Foundation.
14*cdf0e10cSrcweir  *
15*cdf0e10cSrcweir  * OpenOffice.org is distributed in the hope that it will be useful,
16*cdf0e10cSrcweir  * but WITHOUT ANY WARRANTY; without even the implied warranty of
17*cdf0e10cSrcweir  * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
18*cdf0e10cSrcweir  * GNU Lesser General Public License version 3 for more details
19*cdf0e10cSrcweir  * (a copy is included in the LICENSE file that accompanied this code).
20*cdf0e10cSrcweir  *
21*cdf0e10cSrcweir  * You should have received a copy of the GNU Lesser General Public License
22*cdf0e10cSrcweir  * version 3 along with OpenOffice.org.  If not, see
23*cdf0e10cSrcweir  * <http://www.openoffice.org/license.html>
24*cdf0e10cSrcweir  * for a copy of the LGPLv3 License.
25*cdf0e10cSrcweir  *
26*cdf0e10cSrcweir  ************************************************************************/
27*cdf0e10cSrcweir 
28*cdf0e10cSrcweir // MARKER(update_precomp.py): autogen include statement, do not remove
29*cdf0e10cSrcweir #include "precompiled_connectivity.hxx"
30*cdf0e10cSrcweir #include "ado/AUser.hxx"
31*cdf0e10cSrcweir #include "ado/ACatalog.hxx"
32*cdf0e10cSrcweir #include "ado/AGroups.hxx"
33*cdf0e10cSrcweir #include <cppuhelper/typeprovider.hxx>
34*cdf0e10cSrcweir #include <comphelper/sequence.hxx>
35*cdf0e10cSrcweir #include <com/sun/star/sdbc/XRow.hpp>
36*cdf0e10cSrcweir #include <com/sun/star/sdbc/XResultSet.hpp>
37*cdf0e10cSrcweir #ifndef _CONNECTIVITY_ADO_BCONNECTION_HXX_
38*cdf0e10cSrcweir #include "ado/AConnection.hxx"
39*cdf0e10cSrcweir #endif
40*cdf0e10cSrcweir #include "ado/Awrapado.hxx"
41*cdf0e10cSrcweir 
42*cdf0e10cSrcweir using namespace connectivity::ado;
43*cdf0e10cSrcweir using namespace com::sun::star::uno;
44*cdf0e10cSrcweir using namespace com::sun::star::lang;
45*cdf0e10cSrcweir using namespace com::sun::star::beans;
46*cdf0e10cSrcweir using namespace com::sun::star::sdbc;
47*cdf0e10cSrcweir 
48*cdf0e10cSrcweir // -------------------------------------------------------------------------
49*cdf0e10cSrcweir OAdoUser::OAdoUser(OCatalog* _pParent,sal_Bool _bCase, ADOUser* _pUser)
50*cdf0e10cSrcweir 	: OUser_TYPEDEF(_bCase)
51*cdf0e10cSrcweir 	,m_pCatalog(_pParent)
52*cdf0e10cSrcweir {
53*cdf0e10cSrcweir 	construct();
54*cdf0e10cSrcweir 
55*cdf0e10cSrcweir 	if(_pUser)
56*cdf0e10cSrcweir 		m_aUser = WpADOUser(_pUser);
57*cdf0e10cSrcweir 	else
58*cdf0e10cSrcweir 		m_aUser.Create();
59*cdf0e10cSrcweir }
60*cdf0e10cSrcweir // -------------------------------------------------------------------------
61*cdf0e10cSrcweir OAdoUser::OAdoUser(OCatalog* _pParent,sal_Bool _bCase,   const ::rtl::OUString& _Name)
62*cdf0e10cSrcweir 	: OUser_TYPEDEF(_Name,_bCase)
63*cdf0e10cSrcweir 	, m_pCatalog(_pParent)
64*cdf0e10cSrcweir {
65*cdf0e10cSrcweir 	construct();
66*cdf0e10cSrcweir 	m_aUser.Create();
67*cdf0e10cSrcweir 	m_aUser.put_Name(_Name);
68*cdf0e10cSrcweir }
69*cdf0e10cSrcweir // -------------------------------------------------------------------------
70*cdf0e10cSrcweir void OAdoUser::refreshGroups()
71*cdf0e10cSrcweir {
72*cdf0e10cSrcweir 	TStringVector aVector;
73*cdf0e10cSrcweir 	WpADOGroups aGroups(m_aUser.get_Groups());
74*cdf0e10cSrcweir 	aGroups.fillElementNames(aVector);
75*cdf0e10cSrcweir 	if(m_pGroups)
76*cdf0e10cSrcweir 		m_pGroups->reFill(aVector);
77*cdf0e10cSrcweir 	else
78*cdf0e10cSrcweir 		m_pGroups = new OGroups(m_pCatalog,m_aMutex,aVector,aGroups,isCaseSensitive());
79*cdf0e10cSrcweir }
80*cdf0e10cSrcweir //--------------------------------------------------------------------------
81*cdf0e10cSrcweir Sequence< sal_Int8 > OAdoUser::getUnoTunnelImplementationId()
82*cdf0e10cSrcweir {
83*cdf0e10cSrcweir 	static ::cppu::OImplementationId * pId = 0;
84*cdf0e10cSrcweir 	if (! pId)
85*cdf0e10cSrcweir 	{
86*cdf0e10cSrcweir 		::osl::MutexGuard aGuard( ::osl::Mutex::getGlobalMutex() );
87*cdf0e10cSrcweir 		if (! pId)
88*cdf0e10cSrcweir 		{
89*cdf0e10cSrcweir 			static ::cppu::OImplementationId aId;
90*cdf0e10cSrcweir 			pId = &aId;
91*cdf0e10cSrcweir 		}
92*cdf0e10cSrcweir 	}
93*cdf0e10cSrcweir 	return pId->getImplementationId();
94*cdf0e10cSrcweir }
95*cdf0e10cSrcweir 
96*cdf0e10cSrcweir // com::sun::star::lang::XUnoTunnel
97*cdf0e10cSrcweir //------------------------------------------------------------------
98*cdf0e10cSrcweir sal_Int64 OAdoUser::getSomething( const Sequence< sal_Int8 > & rId ) throw (RuntimeException)
99*cdf0e10cSrcweir {
100*cdf0e10cSrcweir 	return (rId.getLength() == 16 && 0 == rtl_compareMemory(getUnoTunnelImplementationId().getConstArray(),  rId.getConstArray(), 16 ) )
101*cdf0e10cSrcweir 				? reinterpret_cast< sal_Int64 >( this )
102*cdf0e10cSrcweir 				: OUser_TYPEDEF::getSomething(rId);
103*cdf0e10cSrcweir }
104*cdf0e10cSrcweir 
105*cdf0e10cSrcweir // -------------------------------------------------------------------------
106*cdf0e10cSrcweir void OAdoUser::setFastPropertyValue_NoBroadcast(sal_Int32 nHandle,const Any& rValue)throw (Exception)
107*cdf0e10cSrcweir {
108*cdf0e10cSrcweir 	if(m_aUser.IsValid())
109*cdf0e10cSrcweir 	{
110*cdf0e10cSrcweir 
111*cdf0e10cSrcweir 		switch(nHandle)
112*cdf0e10cSrcweir 		{
113*cdf0e10cSrcweir 			case PROPERTY_ID_NAME:
114*cdf0e10cSrcweir 				{
115*cdf0e10cSrcweir 					::rtl::OUString aVal;
116*cdf0e10cSrcweir 					rValue >>= aVal;
117*cdf0e10cSrcweir 					m_aUser.put_Name(aVal);
118*cdf0e10cSrcweir 				}
119*cdf0e10cSrcweir 				break;
120*cdf0e10cSrcweir 		}
121*cdf0e10cSrcweir 	}
122*cdf0e10cSrcweir }
123*cdf0e10cSrcweir // -------------------------------------------------------------------------
124*cdf0e10cSrcweir void OAdoUser::getFastPropertyValue(Any& rValue,sal_Int32 nHandle) const
125*cdf0e10cSrcweir {
126*cdf0e10cSrcweir 	if(m_aUser.IsValid())
127*cdf0e10cSrcweir 	{
128*cdf0e10cSrcweir 		switch(nHandle)
129*cdf0e10cSrcweir 		{
130*cdf0e10cSrcweir 			case PROPERTY_ID_NAME:
131*cdf0e10cSrcweir 				rValue <<= m_aUser.get_Name();
132*cdf0e10cSrcweir 				break;
133*cdf0e10cSrcweir 		}
134*cdf0e10cSrcweir 	}
135*cdf0e10cSrcweir }
136*cdf0e10cSrcweir // -------------------------------------------------------------------------
137*cdf0e10cSrcweir OUserExtend::OUserExtend(OCatalog* _pParent,sal_Bool _bCase,	ADOUser* _pUser)
138*cdf0e10cSrcweir 	: OAdoUser(_pParent,_bCase,_pUser)
139*cdf0e10cSrcweir {
140*cdf0e10cSrcweir }
141*cdf0e10cSrcweir // -------------------------------------------------------------------------
142*cdf0e10cSrcweir OUserExtend::OUserExtend(OCatalog* _pParent,sal_Bool _bCase, const ::rtl::OUString& _Name)
143*cdf0e10cSrcweir 	: OAdoUser(_pParent,_bCase,_Name)
144*cdf0e10cSrcweir {
145*cdf0e10cSrcweir }
146*cdf0e10cSrcweir 
147*cdf0e10cSrcweir // -------------------------------------------------------------------------
148*cdf0e10cSrcweir void OUserExtend::construct()
149*cdf0e10cSrcweir {
150*cdf0e10cSrcweir 	OUser_TYPEDEF::construct();
151*cdf0e10cSrcweir 	registerProperty(OMetaConnection::getPropMap().getNameByIndex(PROPERTY_ID_PASSWORD),	PROPERTY_ID_PASSWORD,0,&m_Password,::getCppuType(reinterpret_cast< ::rtl::OUString*>(NULL)));
152*cdf0e10cSrcweir }
153*cdf0e10cSrcweir // -----------------------------------------------------------------------------
154*cdf0e10cSrcweir cppu::IPropertyArrayHelper* OUserExtend::createArrayHelper() const
155*cdf0e10cSrcweir {
156*cdf0e10cSrcweir 	Sequence< com::sun::star::beans::Property > aProps;
157*cdf0e10cSrcweir 	describeProperties(aProps);
158*cdf0e10cSrcweir 	return new cppu::OPropertyArrayHelper(aProps);
159*cdf0e10cSrcweir }
160*cdf0e10cSrcweir // -------------------------------------------------------------------------
161*cdf0e10cSrcweir cppu::IPropertyArrayHelper & OUserExtend::getInfoHelper()
162*cdf0e10cSrcweir {
163*cdf0e10cSrcweir 	return *OUserExtend_PROP::getArrayHelper();
164*cdf0e10cSrcweir }
165*cdf0e10cSrcweir // -----------------------------------------------------------------------------
166*cdf0e10cSrcweir // -----------------------------------------------------------------------------
167*cdf0e10cSrcweir void SAL_CALL OAdoUser::acquire() throw()
168*cdf0e10cSrcweir {
169*cdf0e10cSrcweir 	OUser_TYPEDEF::acquire();
170*cdf0e10cSrcweir }
171*cdf0e10cSrcweir // -----------------------------------------------------------------------------
172*cdf0e10cSrcweir void SAL_CALL OAdoUser::release() throw()
173*cdf0e10cSrcweir {
174*cdf0e10cSrcweir 	OUser_TYPEDEF::release();
175*cdf0e10cSrcweir }
176*cdf0e10cSrcweir // -----------------------------------------------------------------------------
177*cdf0e10cSrcweir sal_Int32 SAL_CALL OAdoUser::getPrivileges( const ::rtl::OUString& objName, sal_Int32 objType ) throw(SQLException, RuntimeException)
178*cdf0e10cSrcweir {
179*cdf0e10cSrcweir 	::osl::MutexGuard aGuard(m_aMutex);
180*cdf0e10cSrcweir 	checkDisposed(OUser_BASE_TYPEDEF::rBHelper.bDisposed);
181*cdf0e10cSrcweir 
182*cdf0e10cSrcweir 	return ADOS::mapAdoRights2Sdbc(m_aUser.GetPermissions(objName, ADOS::mapObjectType2Ado(objType)));
183*cdf0e10cSrcweir }
184*cdf0e10cSrcweir // -------------------------------------------------------------------------
185*cdf0e10cSrcweir sal_Int32 SAL_CALL OAdoUser::getGrantablePrivileges( const ::rtl::OUString& objName, sal_Int32 objType ) throw(SQLException, RuntimeException)
186*cdf0e10cSrcweir {
187*cdf0e10cSrcweir 	::osl::MutexGuard aGuard(m_aMutex);
188*cdf0e10cSrcweir 	checkDisposed(OUser_BASE_TYPEDEF::rBHelper.bDisposed);
189*cdf0e10cSrcweir 
190*cdf0e10cSrcweir 	sal_Int32 nRights = 0;
191*cdf0e10cSrcweir 	RightsEnum eRights = m_aUser.GetPermissions(objName, ADOS::mapObjectType2Ado(objType));
192*cdf0e10cSrcweir 	if((eRights & adRightWithGrant) == adRightWithGrant)
193*cdf0e10cSrcweir 		nRights = ADOS::mapAdoRights2Sdbc(eRights);
194*cdf0e10cSrcweir 	ADOS::ThrowException(*m_pCatalog->getConnection()->getConnection(),*this);
195*cdf0e10cSrcweir 	return nRights;
196*cdf0e10cSrcweir }
197*cdf0e10cSrcweir // -------------------------------------------------------------------------
198*cdf0e10cSrcweir void SAL_CALL OAdoUser::grantPrivileges( const ::rtl::OUString& objName, sal_Int32 objType, sal_Int32 objPrivileges ) throw(SQLException, RuntimeException)
199*cdf0e10cSrcweir {
200*cdf0e10cSrcweir 	::osl::MutexGuard aGuard(m_aMutex);
201*cdf0e10cSrcweir 	checkDisposed(OUser_BASE_TYPEDEF::rBHelper.bDisposed);
202*cdf0e10cSrcweir 	m_aUser.SetPermissions(objName,ADOS::mapObjectType2Ado(objType),adAccessGrant,RightsEnum(ADOS::mapRights2Ado(objPrivileges)));
203*cdf0e10cSrcweir 	ADOS::ThrowException(*m_pCatalog->getConnection()->getConnection(),*this);
204*cdf0e10cSrcweir }
205*cdf0e10cSrcweir // -------------------------------------------------------------------------
206*cdf0e10cSrcweir void SAL_CALL OAdoUser::revokePrivileges( const ::rtl::OUString& objName, sal_Int32 objType, sal_Int32 objPrivileges ) throw(SQLException, RuntimeException)
207*cdf0e10cSrcweir {
208*cdf0e10cSrcweir 	::osl::MutexGuard aGuard(m_aMutex);
209*cdf0e10cSrcweir 	checkDisposed(OUser_BASE_TYPEDEF::rBHelper.bDisposed);
210*cdf0e10cSrcweir     m_aUser.SetPermissions(objName,ADOS::mapObjectType2Ado(objType),adAccessRevoke,RightsEnum(ADOS::mapRights2Ado(objPrivileges)));
211*cdf0e10cSrcweir 	ADOS::ThrowException(*m_pCatalog->getConnection()->getConnection(),*this);
212*cdf0e10cSrcweir }
213*cdf0e10cSrcweir // -----------------------------------------------------------------------------
214*cdf0e10cSrcweir // XUser
215*cdf0e10cSrcweir void SAL_CALL OAdoUser::changePassword( const ::rtl::OUString& objPassword, const ::rtl::OUString& newPassword ) throw(SQLException, RuntimeException)
216*cdf0e10cSrcweir {
217*cdf0e10cSrcweir 	::osl::MutexGuard aGuard(m_aMutex);
218*cdf0e10cSrcweir 	checkDisposed(OUser_BASE_TYPEDEF::rBHelper.bDisposed);
219*cdf0e10cSrcweir 	m_aUser.ChangePassword(objPassword,newPassword);
220*cdf0e10cSrcweir 	ADOS::ThrowException(*m_pCatalog->getConnection()->getConnection(),*this);
221*cdf0e10cSrcweir }
222*cdf0e10cSrcweir // -----------------------------------------------------------------------------
223*cdf0e10cSrcweir 
224*cdf0e10cSrcweir 
225*cdf0e10cSrcweir 
226*cdf0e10cSrcweir 
227*cdf0e10cSrcweir 
228