DB2 catalog tables

[prasad_mainframe]

Hi,

I would like to know where(into which catalog tables) DB2 makes entries,
when I execute either GRANT or REVOKE stmt.
ex: GRANT SELECT ON TABLE1 TO USER1;
Now, in which catalog table I can find that USER1 has been given access for SELECT on TABLE1.

thanks,
prasad_mainframe

[muraligaru1]

Hi Prasad,

I have found following tables, when i done some R&D.

SYSIBM.SYSUSERAUTH
SYSIBM.SYSPACKAUTH
SYSIBM.SYSPLANAUTH
SYSIBM.SYSRESAUTH
SYSIBM.SYSTABAUTH
SYSDBAUTH


SYSTABAUTH table may contain the requested information, check out this table.


Regards,
Murali