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?

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

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

grant dbadm authority and then chk with get authorization command and wht is the command ur using to grant dbadm
regds
Paul

db2 grant dbadm on database to user username.

in the output above, it is showing 'YES' for dbadm...

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

>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".