If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

 
Go Back  dBforums > Database Server Software > DB2 > priviledge in db2

Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1 (permalink)  
Old 09-23-10, 04:52
db2cap db2cap is offline
Registered User
 
Join Date: May 2010
Posts: 87
priviledge in db2

Hi,
I want to grant 'DBADM' priviledge to a user xyz but not 'quiesce_connect' which is implictly provided when you make him DBADM. Is it possible to revoke only 'quiesce_connect' from user having dbadm rights?
Reply With Quote
  #2 (permalink)  
Old 09-23-10, 09:25
Mathew_paul Mathew_paul is offline
Registered User
 
Join Date: Oct 2007
Posts: 200
u can try this its not going take much time, grant a user dbadm and try to revoke quiesce_connect and chk the get authorization details simple, let us know the result

it won't allow as i already holds the dbadm

regds
Paul

Last edited by Mathew_paul; 09-23-10 at 09:29.
Reply With Quote
  #3 (permalink)  
Old 09-23-10, 09:37
db2cap db2cap is offline
Registered User
 
Join Date: May 2010
Posts: 87
It does not allow to revoke saying the user doesn't hold the priviledge. Also, why does it show 'NO' in indirect quiesce_connect even after giving dbadm authority. Find the below output

Administrative Authorizations for Current User

Direct SYSADM authority = NO
Direct SYSCTRL authority = NO
Direct SYSMAINT authority = NO
Direct DBADM authority = YES
Direct CREATETAB authority = NO
Direct BINDADD authority = NO
Direct CONNECT authority = NO
Direct CREATE_NOT_FENC authority = NO
Direct IMPLICIT_SCHEMA authority = NO
Direct LOAD authority = NO
Direct QUIESCE_CONNECT authority = NO
Direct CREATE_EXTERNAL_ROUTINE authority = NO
Direct SYSMON authority = NO

Indirect SYSADM authority = NO
Indirect SYSCTRL authority = NO
Indirect SYSMAINT authority = NO
Indirect DBADM authority = NO
Indirect CREATETAB authority = NO
Indirect BINDADD authority = NO
Indirect CONNECT authority = NO
Indirect CREATE_NOT_FENC authority = NO
Indirect IMPLICIT_SCHEMA authority = NO
Indirect LOAD authority = NO
Indirect QUIESCE_CONNECT authority = NO
Indirect CREATE_EXTERNAL_ROUTINE authority = NO
Indirect SYSMON authority = NO
Reply With Quote
  #4 (permalink)  
Old 09-23-10, 09:51
Mathew_paul Mathew_paul is offline
Registered User
 
Join Date: Oct 2007
Posts: 200
grant dbadm authority and then chk with get authorization command and wht is the command ur using to grant dbadm
regds
Paul
Reply With Quote
  #5 (permalink)  
Old 09-23-10, 10:22
db2cap db2cap is offline
Registered User
 
Join Date: May 2010
Posts: 87
db2 grant dbadm on database to user username.

in the output above, it is showing 'YES' for dbadm...
Reply With Quote
  #6 (permalink)  
Old 09-24-10, 06:53
Mathew_paul Mathew_paul is offline
Registered User
 
Join Date: Oct 2007
Posts: 200
db2 version pls .... usually dbadm defaulty grant all his feature but i don't know how ur get authorizations is giving only 'YES' for dbadm and no to others... group ur input pls.....
regds
paul
Reply With Quote
  #7 (permalink)  
Old 09-24-10, 10:18
db2cap db2cap is offline
Registered User
 
Join Date: May 2010
Posts: 87
>db2level
DB21085I Instance "DB2" uses "32" bits and DB2 code release "SQL09071" with
level identifier "08020107".
Informational tokens are "DB2 v9.7.100.177", "s091114", "IP23028", and Fix Pack

"1".
Product is installed at "C:\PROGRA~1\IBM\SQLLIB" with DB2 Copy Name "DB2COPY1".
Reply With Quote
Reply

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On