diff options
Diffstat (limited to 'dbaccess/source/ui/control/TableGrantCtrl.cxx')
| -rw-r--r-- | dbaccess/source/ui/control/TableGrantCtrl.cxx | 500 |
1 files changed, 500 insertions, 0 deletions
diff --git a/dbaccess/source/ui/control/TableGrantCtrl.cxx b/dbaccess/source/ui/control/TableGrantCtrl.cxx new file mode 100644 index 000000000000..991dca50d804 --- /dev/null +++ b/dbaccess/source/ui/control/TableGrantCtrl.cxx @@ -0,0 +1,500 @@ +/* -*- Mode: C++; tab-width: 4; indent-tabs-mode: nil; c-basic-offset: 4 -*- */ +/************************************************************************* + * + * DO NOT ALTER OR REMOVE COPYRIGHT NOTICES OR THIS FILE HEADER. + * + * Copyright 2000, 2010 Oracle and/or its affiliates. + * + * OpenOffice.org - a multi-platform office productivity suite + * + * This file is part of OpenOffice.org. + * + * OpenOffice.org is free software: you can redistribute it and/or modify + * it under the terms of the GNU Lesser General Public License version 3 + * only, as published by the Free Software Foundation. + * + * OpenOffice.org is distributed in the hope that it will be useful, + * but WITHOUT ANY WARRANTY; without even the implied warranty of + * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the + * GNU Lesser General Public License version 3 for more details + * (a copy is included in the LICENSE file that accompanied this code). + * + * You should have received a copy of the GNU Lesser General Public License + * version 3 along with OpenOffice.org. If not, see + * <http://www.openoffice.org/license.html> + * for a copy of the LGPLv3 License. + * + ************************************************************************/ + +// MARKER(update_precomp.py): autogen include statement, do not remove +#include "precompiled_dbaccess.hxx" +#include "TableGrantCtrl.hxx" +#include <tools/debug.hxx> +#include <com/sun/star/sdbcx/XTablesSupplier.hpp> +#include <com/sun/star/sdbcx/Privilege.hpp> +#include <com/sun/star/sdbcx/PrivilegeObject.hpp> +#include <com/sun/star/sdbcx/XUsersSupplier.hpp> +#include <com/sun/star/sdbcx/XAuthorizable.hpp> +#include "dbu_control.hrc" +#include "UITools.hxx" + +using namespace ::com::sun::star::accessibility; +using namespace ::com::sun::star::container; +using namespace ::com::sun::star::sdbcx; +using namespace ::com::sun::star::sdbc; +using namespace ::com::sun::star::uno; +using namespace ::dbaui; +using namespace ::svt; + +const USHORT COL_TABLE_NAME = 1; +const USHORT COL_SELECT = 2; +const USHORT COL_INSERT = 3; +const USHORT COL_DELETE = 4; +const USHORT COL_UPDATE = 5; +const USHORT COL_ALTER = 6; +const USHORT COL_REF = 7; +const USHORT COL_DROP = 8; + +DBG_NAME(OTableGrantControl) + +//================================================================================ +// OTableGrantControl +//================================================================================ +OTableGrantControl::OTableGrantControl( Window* pParent,const ResId& _RsId) + :EditBrowseBox( pParent,_RsId, EBBF_SMART_TAB_TRAVEL | EBBF_NOROWPICTURE ) + ,m_pCheckCell( NULL ) + ,m_pEdit( NULL ) + ,m_nDataPos( 0 ) + ,m_bEnable(TRUE) + ,m_nDeactivateEvent(0) +{ + DBG_CTOR(OTableGrantControl,NULL); + ////////////////////////////////////////////////////////////////////// + // Spalten einfuegen + USHORT i=1; + InsertDataColumn( i, String(ModuleRes(STR_TABLE_PRIV_NAME) ), 75); + FreezeColumn(i++); + InsertDataColumn( i++, String(ModuleRes(STR_TABLE_PRIV_SELECT)), 75); + InsertDataColumn( i++, String(ModuleRes(STR_TABLE_PRIV_INSERT)), 75); + InsertDataColumn( i++, String(ModuleRes(STR_TABLE_PRIV_DELETE)), 75); + InsertDataColumn( i++, String(ModuleRes(STR_TABLE_PRIV_UPDATE)), 75); + InsertDataColumn( i++, String(ModuleRes(STR_TABLE_PRIV_ALTER)), 75); + InsertDataColumn( i++, String(ModuleRes(STR_TABLE_PRIV_REFERENCE)), 75); + InsertDataColumn( i++, String(ModuleRes(STR_TABLE_PRIV_DROP)), 75); + + while(--i) + SetColumnWidth(i,GetAutoColumnWidth(i)); +} + +//------------------------------------------------------------------------ +OTableGrantControl::~OTableGrantControl() +{ + DBG_DTOR(OTableGrantControl,NULL); + if (m_nDeactivateEvent) + { + Application::RemoveUserEvent(m_nDeactivateEvent); + m_nDeactivateEvent = 0; + } + + delete m_pCheckCell; + delete m_pEdit; + + m_xTables = NULL; +} +// ----------------------------------------------------------------------------- +void OTableGrantControl::setTablesSupplier(const Reference< XTablesSupplier >& _xTablesSup) +{ + // first we need the users + Reference< XUsersSupplier> xUserSup(_xTablesSup,UNO_QUERY); + if(xUserSup.is()) + m_xUsers = xUserSup->getUsers(); + + // second we need the tables to determine which privileges the user has + if(_xTablesSup.is()) + m_xTables = _xTablesSup->getTables(); + + if(m_xTables.is()) + m_aTableNames = m_xTables->getElementNames(); + + OSL_ENSURE(m_xUsers.is(),"No user access supported!"); + OSL_ENSURE(m_xTables.is(),"No tables supported!"); +} +// ----------------------------------------------------------------------------- +void OTableGrantControl::setORB(const Reference< ::com::sun::star::lang::XMultiServiceFactory>& _xORB) +{ + m_xORB = _xORB; +} +//------------------------------------------------------------------------ +void OTableGrantControl::UpdateTables() +{ + RemoveRows(); + + if(m_xTables.is()) + RowInserted(0, m_aTableNames.getLength()); + // m_bEnable = m_xDb->GetUser() != ((OUserAdmin*)GetParent())->GetUser(); +} +//------------------------------------------------------------------------ +void OTableGrantControl::Init() +{ + DBG_CHKTHIS(OTableGrantControl,NULL); + EditBrowseBox::Init(); + + ////////////////////////////////////////////////////////////////////// + // ComboBox instanzieren + if(!m_pCheckCell) + { + m_pCheckCell = new CheckBoxControl( &GetDataWindow() ); + m_pCheckCell->GetBox().EnableTriState(FALSE); + + m_pEdit = new Edit( &GetDataWindow() ); + m_pEdit->SetReadOnly(); + m_pEdit->Enable(FALSE); + } + + UpdateTables(); + ////////////////////////////////////////////////////////////////////// + // Browser Mode setzen + BrowserMode nMode = BROWSER_COLUMNSELECTION | BROWSER_HLINESFULL | BROWSER_VLINESFULL | + BROWSER_HIDECURSOR | BROWSER_HIDESELECT; + + SetMode(nMode); +} + +//------------------------------------------------------------------------------ +void OTableGrantControl::Resize() +{ + DBG_CHKTHIS(OTableGrantControl,NULL); + EditBrowseBox::Resize(); +} + +//------------------------------------------------------------------------------ +long OTableGrantControl::PreNotify(NotifyEvent& rNEvt) +{ + DBG_CHKTHIS(OTableGrantControl,NULL); + if (rNEvt.GetType() == EVENT_LOSEFOCUS) + if (!HasChildPathFocus()) + { + if (m_nDeactivateEvent) + Application::RemoveUserEvent(m_nDeactivateEvent); + m_nDeactivateEvent = Application::PostUserEvent(LINK(this, OTableGrantControl, AsynchDeactivate)); + } + if (rNEvt.GetType() == EVENT_GETFOCUS) + { + if (m_nDeactivateEvent) + Application::RemoveUserEvent(m_nDeactivateEvent); + m_nDeactivateEvent = Application::PostUserEvent(LINK(this, OTableGrantControl, AsynchActivate)); + } + return EditBrowseBox::PreNotify(rNEvt); +} + +//------------------------------------------------------------------------------ +IMPL_LINK(OTableGrantControl, AsynchActivate, void*, EMPTYARG) +{ + m_nDeactivateEvent = 0; + ActivateCell(); + return 0L; +} + +//------------------------------------------------------------------------------ +IMPL_LINK(OTableGrantControl, AsynchDeactivate, void*, EMPTYARG) +{ + m_nDeactivateEvent = 0; + DeactivateCell(); + return 0L; +} + +//------------------------------------------------------------------------------ +BOOL OTableGrantControl::IsTabAllowed(BOOL bForward) const +{ + DBG_CHKTHIS(OTableGrantControl,NULL); + long nRow = GetCurRow(); + USHORT nCol = GetCurColumnId(); + + if (bForward && (nCol == 2) && (nRow == GetRowCount() - 1)) + return FALSE; + + if (!bForward && (nCol == 1) && (nRow == 0)) + return FALSE; + + return EditBrowseBox::IsTabAllowed(bForward); +} +//------------------------------------------------------------------------------ +#define GRANT_REVOKE_RIGHT(what) \ + if(m_pCheckCell->GetBox().IsChecked()) \ + xAuth->grantPrivileges(sTableName,PrivilegeObject::TABLE,what);\ + else \ + xAuth->revokePrivileges(sTableName,PrivilegeObject::TABLE,what) + +//------------------------------------------------------------------------------ +BOOL OTableGrantControl::SaveModified() +{ + DBG_CHKTHIS(OTableGrantControl,NULL); + + sal_Int32 nRow = GetCurRow(); + if(nRow == -1 || nRow >= m_aTableNames.getLength()) + return FALSE; + + ::rtl::OUString sTableName = m_aTableNames[nRow]; + BOOL bErg = TRUE; + try + { + + if ( m_xUsers->hasByName(m_sUserName) ) + { + Reference<XAuthorizable> xAuth(m_xUsers->getByName(m_sUserName),UNO_QUERY); + if ( xAuth.is() ) + { + switch( GetCurColumnId() ) + { + case COL_INSERT: + GRANT_REVOKE_RIGHT(Privilege::INSERT); + break; + case COL_DELETE: + GRANT_REVOKE_RIGHT(Privilege::DELETE); + break; + case COL_UPDATE: + GRANT_REVOKE_RIGHT(Privilege::UPDATE); + break; + case COL_ALTER: + GRANT_REVOKE_RIGHT(Privilege::ALTER); + break; + case COL_SELECT: + GRANT_REVOKE_RIGHT(Privilege::SELECT); + break; + case COL_REF: + GRANT_REVOKE_RIGHT(Privilege::REFERENCE); + break; + case COL_DROP: + GRANT_REVOKE_RIGHT(Privilege::DROP); + break; + } + fillPrivilege(nRow); + } + } + } + catch(SQLException& e) + { + bErg = FALSE; + ::dbaui::showError(::dbtools::SQLExceptionInfo(e),GetParent(),m_xORB); + } + if(bErg && Controller().Is()) + Controller()->ClearModified(); + if(!bErg) + UpdateTables(); + + return bErg; +} + +//------------------------------------------------------------------------------ +String OTableGrantControl::GetCellText( long nRow, USHORT nColId ) const +{ + DBG_CHKTHIS(OTableGrantControl,NULL); + if(COL_TABLE_NAME == nColId) + return m_aTableNames[nRow]; + + sal_Int32 nPriv = 0; + TTablePrivilegeMap::const_iterator aFind = findPrivilege(nRow); + if(aFind != m_aPrivMap.end()) + nPriv = aFind->second.nRights; + + return String::CreateFromInt32(isAllowed(nColId,nPriv) ? 1 :0); +} + +//------------------------------------------------------------------------------ +void OTableGrantControl::InitController( CellControllerRef& /*rController*/, long nRow, USHORT nColumnId ) +{ + DBG_CHKTHIS(OTableGrantControl,NULL); + String sTablename = m_aTableNames[nRow]; + // special case for tablename + if(nColumnId == COL_TABLE_NAME) + m_pEdit->SetText(sTablename); + else + { + // get the privileges from the user + TTablePrivilegeMap::const_iterator aFind = findPrivilege(nRow); + m_pCheckCell->GetBox().Check(aFind != m_aPrivMap.end() ? isAllowed(nColumnId,aFind->second.nRights) : FALSE); + } +} +// ----------------------------------------------------------------------------- +void OTableGrantControl::fillPrivilege(sal_Int32 _nRow) const +{ + + if ( m_xUsers->hasByName(m_sUserName) ) + { + try + { + Reference<XAuthorizable> xAuth(m_xUsers->getByName(m_sUserName),UNO_QUERY); + if ( xAuth.is() ) + { + // get the privileges + TPrivileges nRights; + nRights.nRights = xAuth->getPrivileges(m_aTableNames[_nRow],PrivilegeObject::TABLE); + if(m_xGrantUser.is()) + nRights.nWithGrant = m_xGrantUser->getGrantablePrivileges(m_aTableNames[_nRow],PrivilegeObject::TABLE); + else + nRights.nWithGrant = 0; + + m_aPrivMap[m_aTableNames[_nRow]] = nRights; + } + } + catch(SQLException& e) + { + ::dbaui::showError(::dbtools::SQLExceptionInfo(e),GetParent(),m_xORB); + } + catch(Exception& ) + { + } + } +} +// ----------------------------------------------------------------------------- +sal_Bool OTableGrantControl::isAllowed(USHORT _nColumnId,sal_Int32 _nPrivilege) const +{ + sal_Bool bAllowed = sal_False; + switch (_nColumnId) + { + case COL_INSERT: + bAllowed = (Privilege::INSERT & _nPrivilege) == Privilege::INSERT; + break; + case COL_DELETE: + bAllowed = (Privilege::DELETE & _nPrivilege) == Privilege::DELETE; + break; + case COL_UPDATE: + bAllowed = (Privilege::UPDATE & _nPrivilege) == Privilege::UPDATE; + break; + case COL_ALTER: + bAllowed = (Privilege::ALTER & _nPrivilege) == Privilege::ALTER; + break; + case COL_SELECT: + bAllowed = (Privilege::SELECT & _nPrivilege) == Privilege::SELECT; + break; + case COL_REF: + bAllowed = (Privilege::REFERENCE & _nPrivilege) == Privilege::REFERENCE; + break; + case COL_DROP: + bAllowed = (Privilege::DROP & _nPrivilege) == Privilege::DROP; + break; + } + return bAllowed; +} +// ----------------------------------------------------------------------------- +void OTableGrantControl::setUserName(const ::rtl::OUString _sUserName) +{ + m_sUserName = _sUserName; + m_aPrivMap = TTablePrivilegeMap(); +} +// ----------------------------------------------------------------------------- +void OTableGrantControl::setGrantUser(const Reference< XAuthorizable>& _xGrantUser) +{ + OSL_ENSURE(_xGrantUser.is(),"OTableGrantControl::setGrantUser: GrantUser is null!"); + m_xGrantUser = _xGrantUser; +} +//------------------------------------------------------------------------------ +CellController* OTableGrantControl::GetController( long nRow, USHORT nColumnId ) +{ + DBG_CHKTHIS(OTableGrantControl,NULL); + + CellController* pController = NULL; + switch( nColumnId ) + { + case COL_TABLE_NAME: + break; + case COL_INSERT: + case COL_DELETE: + case COL_UPDATE: + case COL_ALTER: + case COL_SELECT: + case COL_REF: + case COL_DROP: + { + TTablePrivilegeMap::const_iterator aFind = findPrivilege(nRow); + if(aFind != m_aPrivMap.end() && isAllowed(nColumnId,aFind->second.nWithGrant)) + pController = new CheckBoxCellController( m_pCheckCell ); + } + break; + default: + ; + } + return pController; +} +//------------------------------------------------------------------------------ +BOOL OTableGrantControl::SeekRow( long nRow ) +{ + DBG_CHKTHIS(OTableGrantControl,NULL); + m_nDataPos = nRow; + + return (nRow <= m_aTableNames.getLength()); +} + +//------------------------------------------------------------------------------ +void OTableGrantControl::PaintCell( OutputDevice& rDev, const Rectangle& rRect, USHORT nColumnId ) const +{ + DBG_CHKTHIS(OTableGrantControl,NULL); + + if(nColumnId != COL_TABLE_NAME) + { + TTablePrivilegeMap::const_iterator aFind = findPrivilege(m_nDataPos); + if(aFind != m_aPrivMap.end()) + PaintTristate(rDev, rRect, isAllowed(nColumnId,aFind->second.nRights) ? STATE_CHECK : STATE_NOCHECK,isAllowed(nColumnId,aFind->second.nWithGrant)); + else + PaintTristate(rDev, rRect, STATE_NOCHECK,FALSE); + } + else + { + String aText(((OTableGrantControl*)this)->GetCellText( m_nDataPos, nColumnId )); + Point aPos( rRect.TopLeft() ); + sal_Int32 nWidth = GetDataWindow().GetTextWidth( aText ); + sal_Int32 nHeight = GetDataWindow().GetTextHeight(); + + if( aPos.X() < rRect.Right() || aPos.X() + nWidth > rRect.Right() || + aPos.Y() < rRect.Top() || aPos.Y() + nHeight > rRect.Bottom() ) + rDev.SetClipRegion( rRect ); + + rDev.DrawText( aPos, aText ); + } + + if( rDev.IsClipRegion() ) + rDev.SetClipRegion(); +} + +//------------------------------------------------------------------------ +void OTableGrantControl::CellModified() +{ + DBG_CHKTHIS(OTableGrantControl,NULL); + EditBrowseBox::CellModified(); + SaveModified(); +} +// ----------------------------------------------------------------------------- +OTableGrantControl::TTablePrivilegeMap::const_iterator OTableGrantControl::findPrivilege(sal_Int32 _nRow) const +{ + TTablePrivilegeMap::const_iterator aFind = m_aPrivMap.find(m_aTableNames[_nRow]); + if(aFind == m_aPrivMap.end()) + { + fillPrivilege(_nRow); + aFind = m_aPrivMap.find(m_aTableNames[_nRow]); + } + return aFind; +} +// ----------------------------------------------------------------------------- +Reference< XAccessible > OTableGrantControl::CreateAccessibleCell( sal_Int32 _nRow, sal_uInt16 _nColumnPos ) +{ + USHORT nColumnId = GetColumnId( _nColumnPos ); + if(nColumnId != COL_TABLE_NAME) + { + TriState eState = STATE_NOCHECK; + BOOL bEnable = FALSE; + TTablePrivilegeMap::const_iterator aFind = findPrivilege(_nRow); + if(aFind != m_aPrivMap.end()) + { + eState = isAllowed(nColumnId,aFind->second.nRights) ? STATE_CHECK : STATE_NOCHECK; + bEnable = isAllowed(nColumnId,aFind->second.nWithGrant); + } + else + eState = STATE_NOCHECK; + + return EditBrowseBox::CreateAccessibleCheckBoxCell( _nRow, _nColumnPos,eState,bEnable ); + } + return EditBrowseBox::CreateAccessibleCell( _nRow, _nColumnPos ); +} +// ----------------------------------------------------------------------------- + +/* vim:set shiftwidth=4 softtabstop=4 expandtab: */ |