Query to see the privileges for a DB2 table

Asked Dec 08 '16 at 03:54

Active Dec 08 '16 at 12:47

Viewed 38 times

I'm just looking for a simple query to see the privileges set for the table .(I have to query it through TOAD for DB2) Note that this link is for the mainframe DB2/z.

select * from SYSIBM. ????

edited Dec 08 '16 at 12:47

mustaccio

18,234
16
48
57

asked Dec 08 '16 at 03:54

code_baby

Which link? Do you need it for LUW or z? – data_henrik Dec 08 '16 at 10:43
1

`SYSTABAUTH`, no? – mustaccio Dec 08 '16 at 12:49
@data_henrik it is for "z" – code_baby Dec 09 '16 at 13:32

Query to see the privileges for a DB2 table

0 Answers0