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_dbaccess.hxx" 26 #ifndef DBAUI_TABLEGRANTCONTROL_HXX 27 #include "TableGrantCtrl.hxx" 28 #endif 29 #ifndef _TOOLS_DEBUG_HXX 30 #include <tools/debug.hxx> 31 #endif 32 #ifndef _COM_SUN_STAR_SDBCX_XTABLESSUPPLIER_HPP_ 33 #include <com/sun/star/sdbcx/XTablesSupplier.hpp> 34 #endif 35 #ifndef _COM_SUN_STAR_SDBCX_PRIVILEGE_HPP_ 36 #include <com/sun/star/sdbcx/Privilege.hpp> 37 #endif 38 #ifndef _COM_SUN_STAR_SDBCX_PRIVILEGEOBJECT_HPP_ 39 #include <com/sun/star/sdbcx/PrivilegeObject.hpp> 40 #endif 41 #ifndef _COM_SUN_STAR_SDBCX_XUSERSSUPPLIER_HPP_ 42 #include <com/sun/star/sdbcx/XUsersSupplier.hpp> 43 #endif 44 #ifndef _COM_SUN_STAR_SDBCX_XAUTHORIZABLE_HPP_ 45 #include <com/sun/star/sdbcx/XAuthorizable.hpp> 46 #endif 47 #ifndef _DBU_CONTROL_HRC_ 48 #include "dbu_control.hrc" 49 #endif 50 #ifndef DBAUI_TOOLS_HXX 51 #include "UITools.hxx" 52 #endif 53 54 using namespace ::com::sun::star::accessibility; 55 using namespace ::com::sun::star::container; 56 using namespace ::com::sun::star::sdbcx; 57 using namespace ::com::sun::star::sdbc; 58 using namespace ::com::sun::star::uno; 59 using namespace ::dbaui; 60 using namespace ::svt; 61 62 const sal_uInt16 COL_TABLE_NAME = 1; 63 const sal_uInt16 COL_SELECT = 2; 64 const sal_uInt16 COL_INSERT = 3; 65 const sal_uInt16 COL_DELETE = 4; 66 const sal_uInt16 COL_UPDATE = 5; 67 const sal_uInt16 COL_ALTER = 6; 68 const sal_uInt16 COL_REF = 7; 69 const sal_uInt16 COL_DROP = 8; 70 71 DBG_NAME(OTableGrantControl) 72 73 //================================================================================ 74 // OTableGrantControl 75 //================================================================================ 76 OTableGrantControl::OTableGrantControl( Window* pParent,const ResId& _RsId) 77 :EditBrowseBox( pParent,_RsId, EBBF_SMART_TAB_TRAVEL | EBBF_NOROWPICTURE ) 78 ,m_pCheckCell( NULL ) 79 ,m_pEdit( NULL ) 80 ,m_nDataPos( 0 ) 81 ,m_bEnable(sal_True) 82 ,m_nDeactivateEvent(0) 83 { 84 DBG_CTOR(OTableGrantControl,NULL); 85 ////////////////////////////////////////////////////////////////////// 86 // Spalten einfuegen 87 sal_uInt16 i=1; 88 InsertDataColumn( i, String(ModuleRes(STR_TABLE_PRIV_NAME) ), 75); 89 FreezeColumn(i++); 90 InsertDataColumn( i++, String(ModuleRes(STR_TABLE_PRIV_SELECT)), 75); 91 InsertDataColumn( i++, String(ModuleRes(STR_TABLE_PRIV_INSERT)), 75); 92 InsertDataColumn( i++, String(ModuleRes(STR_TABLE_PRIV_DELETE)), 75); 93 InsertDataColumn( i++, String(ModuleRes(STR_TABLE_PRIV_UPDATE)), 75); 94 InsertDataColumn( i++, String(ModuleRes(STR_TABLE_PRIV_ALTER)), 75); 95 InsertDataColumn( i++, String(ModuleRes(STR_TABLE_PRIV_REFERENCE)), 75); 96 InsertDataColumn( i++, String(ModuleRes(STR_TABLE_PRIV_DROP)), 75); 97 98 while(--i) 99 SetColumnWidth(i,GetAutoColumnWidth(i)); 100 } 101 102 //------------------------------------------------------------------------ 103 OTableGrantControl::~OTableGrantControl() 104 { 105 DBG_DTOR(OTableGrantControl,NULL); 106 if (m_nDeactivateEvent) 107 { 108 Application::RemoveUserEvent(m_nDeactivateEvent); 109 m_nDeactivateEvent = 0; 110 } 111 112 delete m_pCheckCell; 113 delete m_pEdit; 114 115 m_xTables = NULL; 116 } 117 // ----------------------------------------------------------------------------- 118 void OTableGrantControl::setTablesSupplier(const Reference< XTablesSupplier >& _xTablesSup) 119 { 120 // first we need the users 121 Reference< XUsersSupplier> xUserSup(_xTablesSup,UNO_QUERY); 122 if(xUserSup.is()) 123 m_xUsers = xUserSup->getUsers(); 124 125 // second we need the tables to determine which privileges the user has 126 if(_xTablesSup.is()) 127 m_xTables = _xTablesSup->getTables(); 128 129 if(m_xTables.is()) 130 m_aTableNames = m_xTables->getElementNames(); 131 132 OSL_ENSURE(m_xUsers.is(),"No user access supported!"); 133 OSL_ENSURE(m_xTables.is(),"No tables supported!"); 134 } 135 // ----------------------------------------------------------------------------- 136 void OTableGrantControl::setORB(const Reference< ::com::sun::star::lang::XMultiServiceFactory>& _xORB) 137 { 138 m_xORB = _xORB; 139 } 140 //------------------------------------------------------------------------ 141 void OTableGrantControl::UpdateTables() 142 { 143 RemoveRows(); 144 145 if(m_xTables.is()) 146 RowInserted(0, m_aTableNames.getLength()); 147 // m_bEnable = m_xDb->GetUser() != ((OUserAdmin*)GetParent())->GetUser(); 148 } 149 //------------------------------------------------------------------------ 150 void OTableGrantControl::Init() 151 { 152 DBG_CHKTHIS(OTableGrantControl,NULL); 153 EditBrowseBox::Init(); 154 155 ////////////////////////////////////////////////////////////////////// 156 // ComboBox instanzieren 157 if(!m_pCheckCell) 158 { 159 m_pCheckCell = new CheckBoxControl( &GetDataWindow() ); 160 m_pCheckCell->GetBox().EnableTriState(sal_False); 161 162 m_pEdit = new Edit( &GetDataWindow() ); 163 m_pEdit->SetReadOnly(); 164 m_pEdit->Enable(sal_False); 165 } 166 167 UpdateTables(); 168 ////////////////////////////////////////////////////////////////////// 169 // Browser Mode setzen 170 BrowserMode nMode = BROWSER_COLUMNSELECTION | BROWSER_HLINESFULL | BROWSER_VLINESFULL | 171 BROWSER_HIDECURSOR | BROWSER_HIDESELECT; 172 173 SetMode(nMode); 174 } 175 176 //------------------------------------------------------------------------------ 177 void OTableGrantControl::Resize() 178 { 179 DBG_CHKTHIS(OTableGrantControl,NULL); 180 EditBrowseBox::Resize(); 181 } 182 183 //------------------------------------------------------------------------------ 184 long OTableGrantControl::PreNotify(NotifyEvent& rNEvt) 185 { 186 DBG_CHKTHIS(OTableGrantControl,NULL); 187 if (rNEvt.GetType() == EVENT_LOSEFOCUS) 188 if (!HasChildPathFocus()) 189 { 190 if (m_nDeactivateEvent) 191 Application::RemoveUserEvent(m_nDeactivateEvent); 192 m_nDeactivateEvent = Application::PostUserEvent(LINK(this, OTableGrantControl, AsynchDeactivate)); 193 } 194 if (rNEvt.GetType() == EVENT_GETFOCUS) 195 { 196 if (m_nDeactivateEvent) 197 Application::RemoveUserEvent(m_nDeactivateEvent); 198 m_nDeactivateEvent = Application::PostUserEvent(LINK(this, OTableGrantControl, AsynchActivate)); 199 } 200 return EditBrowseBox::PreNotify(rNEvt); 201 } 202 203 //------------------------------------------------------------------------------ 204 IMPL_LINK(OTableGrantControl, AsynchActivate, void*, EMPTYARG) 205 { 206 m_nDeactivateEvent = 0; 207 ActivateCell(); 208 return 0L; 209 } 210 211 //------------------------------------------------------------------------------ 212 IMPL_LINK(OTableGrantControl, AsynchDeactivate, void*, EMPTYARG) 213 { 214 m_nDeactivateEvent = 0; 215 DeactivateCell(); 216 return 0L; 217 } 218 219 //------------------------------------------------------------------------------ 220 sal_Bool OTableGrantControl::IsTabAllowed(sal_Bool bForward) const 221 { 222 DBG_CHKTHIS(OTableGrantControl,NULL); 223 long nRow = GetCurRow(); 224 sal_uInt16 nCol = GetCurColumnId(); 225 226 if (bForward && (nCol == 2) && (nRow == GetRowCount() - 1)) 227 return sal_False; 228 229 if (!bForward && (nCol == 1) && (nRow == 0)) 230 return sal_False; 231 232 return EditBrowseBox::IsTabAllowed(bForward); 233 } 234 //------------------------------------------------------------------------------ 235 #define GRANT_REVOKE_RIGHT(what) \ 236 if(m_pCheckCell->GetBox().IsChecked()) \ 237 xAuth->grantPrivileges(sTableName,PrivilegeObject::TABLE,what);\ 238 else \ 239 xAuth->revokePrivileges(sTableName,PrivilegeObject::TABLE,what) 240 241 //------------------------------------------------------------------------------ 242 sal_Bool OTableGrantControl::SaveModified() 243 { 244 DBG_CHKTHIS(OTableGrantControl,NULL); 245 246 sal_Int32 nRow = GetCurRow(); 247 if(nRow == -1 || nRow >= m_aTableNames.getLength()) 248 return sal_False; 249 250 ::rtl::OUString sTableName = m_aTableNames[nRow]; 251 sal_Bool bErg = sal_True; 252 try 253 { 254 255 if ( m_xUsers->hasByName(m_sUserName) ) 256 { 257 Reference<XAuthorizable> xAuth(m_xUsers->getByName(m_sUserName),UNO_QUERY); 258 if ( xAuth.is() ) 259 { 260 switch( GetCurColumnId() ) 261 { 262 case COL_INSERT: 263 GRANT_REVOKE_RIGHT(Privilege::INSERT); 264 break; 265 case COL_DELETE: 266 GRANT_REVOKE_RIGHT(Privilege::DELETE); 267 break; 268 case COL_UPDATE: 269 GRANT_REVOKE_RIGHT(Privilege::UPDATE); 270 break; 271 case COL_ALTER: 272 GRANT_REVOKE_RIGHT(Privilege::ALTER); 273 break; 274 case COL_SELECT: 275 GRANT_REVOKE_RIGHT(Privilege::SELECT); 276 break; 277 case COL_REF: 278 GRANT_REVOKE_RIGHT(Privilege::REFERENCE); 279 break; 280 case COL_DROP: 281 GRANT_REVOKE_RIGHT(Privilege::DROP); 282 break; 283 } 284 fillPrivilege(nRow); 285 } 286 } 287 } 288 catch(SQLException& e) 289 { 290 bErg = sal_False; 291 ::dbaui::showError(::dbtools::SQLExceptionInfo(e),GetParent(),m_xORB); 292 } 293 if(bErg && Controller().Is()) 294 Controller()->ClearModified(); 295 if(!bErg) 296 UpdateTables(); 297 298 return bErg; 299 } 300 301 //------------------------------------------------------------------------------ 302 String OTableGrantControl::GetCellText( long nRow, sal_uInt16 nColId ) const 303 { 304 DBG_CHKTHIS(OTableGrantControl,NULL); 305 if(COL_TABLE_NAME == nColId) 306 return m_aTableNames[nRow]; 307 308 sal_Int32 nPriv = 0; 309 TTablePrivilegeMap::const_iterator aFind = findPrivilege(nRow); 310 if(aFind != m_aPrivMap.end()) 311 nPriv = aFind->second.nRights; 312 313 return String::CreateFromInt32(isAllowed(nColId,nPriv) ? 1 :0); 314 } 315 316 //------------------------------------------------------------------------------ 317 void OTableGrantControl::InitController( CellControllerRef& /*rController*/, long nRow, sal_uInt16 nColumnId ) 318 { 319 DBG_CHKTHIS(OTableGrantControl,NULL); 320 String sTablename = m_aTableNames[nRow]; 321 // special case for tablename 322 if(nColumnId == COL_TABLE_NAME) 323 m_pEdit->SetText(sTablename); 324 else 325 { 326 // get the privileges from the user 327 TTablePrivilegeMap::const_iterator aFind = findPrivilege(nRow); 328 m_pCheckCell->GetBox().Check(aFind != m_aPrivMap.end() ? isAllowed(nColumnId,aFind->second.nRights) : sal_False); 329 } 330 } 331 // ----------------------------------------------------------------------------- 332 void OTableGrantControl::fillPrivilege(sal_Int32 _nRow) const 333 { 334 335 if ( m_xUsers->hasByName(m_sUserName) ) 336 { 337 try 338 { 339 Reference<XAuthorizable> xAuth(m_xUsers->getByName(m_sUserName),UNO_QUERY); 340 if ( xAuth.is() ) 341 { 342 // get the privileges 343 TPrivileges nRights; 344 nRights.nRights = xAuth->getPrivileges(m_aTableNames[_nRow],PrivilegeObject::TABLE); 345 if(m_xGrantUser.is()) 346 nRights.nWithGrant = m_xGrantUser->getGrantablePrivileges(m_aTableNames[_nRow],PrivilegeObject::TABLE); 347 else 348 nRights.nWithGrant = 0; 349 350 m_aPrivMap[m_aTableNames[_nRow]] = nRights; 351 } 352 } 353 catch(SQLException& e) 354 { 355 ::dbaui::showError(::dbtools::SQLExceptionInfo(e),GetParent(),m_xORB); 356 } 357 catch(Exception& ) 358 { 359 } 360 } 361 } 362 // ----------------------------------------------------------------------------- 363 sal_Bool OTableGrantControl::isAllowed(sal_uInt16 _nColumnId,sal_Int32 _nPrivilege) const 364 { 365 sal_Bool bAllowed = sal_False; 366 switch (_nColumnId) 367 { 368 case COL_INSERT: 369 bAllowed = (Privilege::INSERT & _nPrivilege) == Privilege::INSERT; 370 break; 371 case COL_DELETE: 372 bAllowed = (Privilege::DELETE & _nPrivilege) == Privilege::DELETE; 373 break; 374 case COL_UPDATE: 375 bAllowed = (Privilege::UPDATE & _nPrivilege) == Privilege::UPDATE; 376 break; 377 case COL_ALTER: 378 bAllowed = (Privilege::ALTER & _nPrivilege) == Privilege::ALTER; 379 break; 380 case COL_SELECT: 381 bAllowed = (Privilege::SELECT & _nPrivilege) == Privilege::SELECT; 382 break; 383 case COL_REF: 384 bAllowed = (Privilege::REFERENCE & _nPrivilege) == Privilege::REFERENCE; 385 break; 386 case COL_DROP: 387 bAllowed = (Privilege::DROP & _nPrivilege) == Privilege::DROP; 388 break; 389 } 390 return bAllowed; 391 } 392 // ----------------------------------------------------------------------------- 393 void OTableGrantControl::setUserName(const ::rtl::OUString _sUserName) 394 { 395 m_sUserName = _sUserName; 396 m_aPrivMap = TTablePrivilegeMap(); 397 } 398 // ----------------------------------------------------------------------------- 399 void OTableGrantControl::setGrantUser(const Reference< XAuthorizable>& _xGrantUser) 400 { 401 OSL_ENSURE(_xGrantUser.is(),"OTableGrantControl::setGrantUser: GrantUser is null!"); 402 m_xGrantUser = _xGrantUser; 403 } 404 //------------------------------------------------------------------------------ 405 CellController* OTableGrantControl::GetController( long nRow, sal_uInt16 nColumnId ) 406 { 407 DBG_CHKTHIS(OTableGrantControl,NULL); 408 409 CellController* pController = NULL; 410 switch( nColumnId ) 411 { 412 case COL_TABLE_NAME: 413 break; 414 case COL_INSERT: 415 case COL_DELETE: 416 case COL_UPDATE: 417 case COL_ALTER: 418 case COL_SELECT: 419 case COL_REF: 420 case COL_DROP: 421 { 422 TTablePrivilegeMap::const_iterator aFind = findPrivilege(nRow); 423 if(aFind != m_aPrivMap.end() && isAllowed(nColumnId,aFind->second.nWithGrant)) 424 pController = new CheckBoxCellController( m_pCheckCell ); 425 } 426 break; 427 default: 428 ; 429 } 430 return pController; 431 } 432 //------------------------------------------------------------------------------ 433 sal_Bool OTableGrantControl::SeekRow( long nRow ) 434 { 435 DBG_CHKTHIS(OTableGrantControl,NULL); 436 m_nDataPos = nRow; 437 438 return (nRow <= m_aTableNames.getLength()); 439 } 440 441 //------------------------------------------------------------------------------ 442 void OTableGrantControl::PaintCell( OutputDevice& rDev, const Rectangle& rRect, sal_uInt16 nColumnId ) const 443 { 444 DBG_CHKTHIS(OTableGrantControl,NULL); 445 446 if(nColumnId != COL_TABLE_NAME) 447 { 448 TTablePrivilegeMap::const_iterator aFind = findPrivilege(m_nDataPos); 449 if(aFind != m_aPrivMap.end()) 450 PaintTristate(rDev, rRect, isAllowed(nColumnId,aFind->second.nRights) ? STATE_CHECK : STATE_NOCHECK,isAllowed(nColumnId,aFind->second.nWithGrant)); 451 else 452 PaintTristate(rDev, rRect, STATE_NOCHECK,sal_False); 453 } 454 else 455 { 456 String aText(((OTableGrantControl*)this)->GetCellText( m_nDataPos, nColumnId )); 457 Point aPos( rRect.TopLeft() ); 458 sal_Int32 nWidth = GetDataWindow().GetTextWidth( aText ); 459 sal_Int32 nHeight = GetDataWindow().GetTextHeight(); 460 461 if( aPos.X() < rRect.Right() || aPos.X() + nWidth > rRect.Right() || 462 aPos.Y() < rRect.Top() || aPos.Y() + nHeight > rRect.Bottom() ) 463 rDev.SetClipRegion( rRect ); 464 465 rDev.DrawText( aPos, aText ); 466 } 467 468 if( rDev.IsClipRegion() ) 469 rDev.SetClipRegion(); 470 } 471 472 //------------------------------------------------------------------------ 473 void OTableGrantControl::CellModified() 474 { 475 DBG_CHKTHIS(OTableGrantControl,NULL); 476 EditBrowseBox::CellModified(); 477 SaveModified(); 478 } 479 // ----------------------------------------------------------------------------- 480 OTableGrantControl::TTablePrivilegeMap::const_iterator OTableGrantControl::findPrivilege(sal_Int32 _nRow) const 481 { 482 TTablePrivilegeMap::const_iterator aFind = m_aPrivMap.find(m_aTableNames[_nRow]); 483 if(aFind == m_aPrivMap.end()) 484 { 485 fillPrivilege(_nRow); 486 aFind = m_aPrivMap.find(m_aTableNames[_nRow]); 487 } 488 return aFind; 489 } 490 // ----------------------------------------------------------------------------- 491 Reference< XAccessible > OTableGrantControl::CreateAccessibleCell( sal_Int32 _nRow, sal_uInt16 _nColumnPos ) 492 { 493 sal_uInt16 nColumnId = GetColumnId( _nColumnPos ); 494 if(nColumnId != COL_TABLE_NAME) 495 { 496 TriState eState = STATE_NOCHECK; 497 sal_Bool bEnable = sal_False; 498 TTablePrivilegeMap::const_iterator aFind = findPrivilege(_nRow); 499 if(aFind != m_aPrivMap.end()) 500 { 501 eState = isAllowed(nColumnId,aFind->second.nRights) ? STATE_CHECK : STATE_NOCHECK; 502 bEnable = isAllowed(nColumnId,aFind->second.nWithGrant); 503 } 504 else 505 eState = STATE_NOCHECK; 506 507 return EditBrowseBox::CreateAccessibleCheckBoxCell( _nRow, _nColumnPos,eState,bEnable ); 508 } 509 return EditBrowseBox::CreateAccessibleCell( _nRow, _nColumnPos ); 510 } 511 // ----------------------------------------------------------------------------- 512 513