Results 1 to 7 of 7
  1. #1
    Join Date
    May 2010
    Posts
    88

    Unanswered: 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?

  2. #2
    Join Date
    Oct 2007
    Posts
    246
    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 10:29.

  3. #3
    Join Date
    May 2010
    Posts
    88
    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

  4. #4
    Join Date
    Oct 2007
    Posts
    246
    grant dbadm authority and then chk with get authorization command and wht is the command ur using to grant dbadm
    regds
    Paul

  5. #5
    Join Date
    May 2010
    Posts
    88
    db2 grant dbadm on database to user username.

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

  6. #6
    Join Date
    Oct 2007
    Posts
    246
    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

  7. #7
    Join Date
    May 2010
    Posts
    88
    >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".

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •