view existing grants on a database / table

[philipose]

Hi db2 gurus,

I am not a DBA. If I have select / connect access to a DB2 database and a few tables in the database, can I view all the grants on that dataase and those tables ? If so can you direct me to which system table should I query on ?

Thanks
Philipose

 

[papadba]

Suggest you ask your dba who can show you how to do this if you are permitted to read these.

Even if you don't have permission to run the query, the dba might be willing to provide the info you want (depending on just what you want).

 

[sathyarams]

What version and fixpak are we talking about here ?

For db2 resoruces visit

http://www.db2click.com

More DB2 questions answered at

http://www.dbforums.com/f8

&

http://www.idug.org/user/UserLogin.asp

 

[sathyarams]

search for "Security routines and views" in the information centre for your version of the product

Sathyaram

For db2 resoruces visit

http://www.db2click.com

More DB2 questions answered at

http://www.dbforums.com/f8

&

http://www.idug.org/user/UserLogin.asp

 

[philipose]

Sathyaram,

I was away for a few days. Here is the verion and fix pack information.

hbuhydpf@usvh2euap2c:/home/hbuhydpf=> db2level
DB21085I Instance "iuiap01" uses "64" bits and DB2 code release "SQL09014"
with level identifier "01050107".
Informational tokens are "DB2 v9.1.0.4", "s080122", "U815768", and Fix Pack
"4a".

Let me do the search as your suggested.

Thanks
Philipose

 

[philipose]

sathyarama,
thank you very much. I got the information needed from SYSCAT.TABAUTH

Thanks
philipose