Hey Folks..
We have DB2 V9.5 running on AIX. How do I determine the SYSADM userid? Also, which system table do I query to determine what userid has auth to which table? I'm a DB2 z/OS DBA and don't see an equivalent table to SYSIBM.SYSTABAUTH. Thanks in advance.
Mike D.

Mike,

IBM - DB2 Version 9.5 for Linux, UNIX and Windows English manuals

This should be your first stop. I think in another thread someone has already pointed out a catalog views.

get dbm cfg -- should give you a list of groups and what access they have. From there if you must know ids in those groups you can do lsgroup group_name (low case)

Thanks Cougar.. I did scour through the manuals, just didn't see anything that gave me userid's and table auths. Just sysschemaauth.

Check out the system catalog views (SYSCAT.*). You might be interested in SYSCAT.TABAUTH in particular.

SYSADM authority is usually assigned to a group, so you can check what group it is:

db2 get dbm cfg | grep SYSADM

then see who is in that group:

lsgroup whatevergroupitwas

Thank you n i Must be an age thing. I totally missed the TABAUTH table. thanks again!