Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

what system/catalog tables show user privileges 1

Status
Not open for further replies.

ddiamond

Programmer
Apr 22, 2005
918
0
0
US
On db2 udb 8.2, what system/catalog tables can I use to determine what object/table privileges a user or group has?
 
SYSCAT.DBAUTH
SYSCAT.TABAUTH
SYSCAT.INDEXAUTH
SYSCAT.COLAUTH
SYSCAT.SCHEMAAUTH
SYSCAT.PASSTHRUAUTH
SYSCAT.PACKAGEAUTH
syscat.schemata
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top