Results 1 to 5 of 5
  1. #1
    Join Date
    Jan 2003
    Posts
    1,595

    How to list users privileges in db2?

    Hi,
    I have created new users in DB2 v9 fp2 for Ret Hat Enterprise Linux. I have also granted users select privileges (db2 grant select on mytable to user1).

    Starting db2 Control Center (db2cc from terminal) I click down pluses to get "Users and Group". Click on Users folder and there is no "user1" listed.

    Do I need to specify anything else to see users in Control Center? I have already press Refresh button (I have also reboot Linux).
    Is there some command to list privileges for all users?
    Thanks,
    Grofaty
    Last edited by grofaty; 04-17-07 at 02:05.

  2. #2
    Join Date
    Jun 2006
    Posts
    471
    you can not see all grants with 1 query, because the authorities are save in different tables
    for the problem, please go to command line - connect to db and try
    db2 select distinct grantee from sysibm.systabauth
    Best Regards, Guy Przytula
    DB2 UDB LUW certified V6/7/8

  3. #3
    Join Date
    Jan 2003
    Posts
    1,595
    Hi,
    thanks a lot. Your help was good starting point.

    Just to write a note: SYSIBM is not adviced to use in select statements, because IBM can change sintax of tables, so I prefer using SYSCAT views.
    Code:
    select * from syscat.tabauth where grantee='USERNAME'
    Thanks,
    Grofaty

  4. #4
    Join Date
    Jul 2006
    Location
    Pune , India
    Posts
    433
    If you are not able to see it even after restart i smell it as Bug.
    V 8.2.7 CC clearly shows you new users added just by refresh
    Rahul Singh
    Certified DB2 9 DBA / Application Developer

  5. #5
    Join Date
    Jan 2003
    Posts
    1,595
    Hi,
    it looks like a bug to me to. I have tried using db2cc on v8 fp9 on Windows and it works fine.
    Thanks,
    Grofaty

Posting Permissions

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