Oct 12, 2005 #1 ddiamond Programmer Apr 22, 2005 918 US On db2 udb 8.2, what system/catalog tables can I use to determine what object/table privileges a user or group has?
On db2 udb 8.2, what system/catalog tables can I use to determine what object/table privileges a user or group has?
Oct 12, 2005 1 #2 rbod Programmer Feb 1, 2005 74 US SYSCAT.DBAUTH SYSCAT.TABAUTH SYSCAT.INDEXAUTH SYSCAT.COLAUTH SYSCAT.SCHEMAAUTH SYSCAT.PASSTHRUAUTH SYSCAT.PACKAGEAUTH syscat.schemata Upvote 0 Downvote
SYSCAT.DBAUTH SYSCAT.TABAUTH SYSCAT.INDEXAUTH SYSCAT.COLAUTH SYSCAT.SCHEMAAUTH SYSCAT.PASSTHRUAUTH SYSCAT.PACKAGEAUTH syscat.schemata
Oct 12, 2005 Thread starter #3 ddiamond Programmer Apr 22, 2005 918 US Thanks rbod. That was exactly what I was looking for. I also just found a useful websit that lists all of the syscat tables with a description: [URL unfurl="true"]http://grdelin.phy.hr/~ivo/Nastava/Baze_podataka/arhiva/sql/db2/rocatv.htm#HDRROCATV[/url] Upvote 0 Downvote
Thanks rbod. That was exactly what I was looking for. I also just found a useful websit that lists all of the syscat tables with a description: [URL unfurl="true"]http://grdelin.phy.hr/~ivo/Nastava/Baze_podataka/arhiva/sql/db2/rocatv.htm#HDRROCATV[/url]