Results 1 to 4 of 4
  1. #1
    Join Date
    Aug 2004
    Posts
    2

    Question Unanswered: Privileges in DB2

    Is there a way to tell which user id has certain privileges in DB2?

    I have queried both the SYSDBAUTH and SYSTABAUTH searching to see
    if there is a way to see a certain user id.

    All I see is DBADM. I want to see the user id's associated with DBADM.

    Thanks, MLVTW :

    ps. I am working on the mainframe using V7.3 of DB2.
    Last edited by mlvtw; 08-31-04 at 19:06.

  2. #2
    Join Date
    Feb 2004
    Posts
    25
    You do the select from SYSTABAUTH and SYSDBAUTH where GRANTEE = 'userid'. Then you'll see any specific authority granted to that ID.

  3. #3
    Join Date
    Feb 2004
    Posts
    25
    I forgot - check SYSUSERAUTH too.

  4. #4
    Join Date
    Aug 2004
    Posts
    2

    Thanks

    Thanks crisscross!

Posting Permissions

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