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

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

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.
Thanks,
Grofaty

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

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