DB2 AS400 privileges

tuvarsha · #1 (**permalink**) 12-29-05, 13:07

What is the SQL query to retrieve the privileges for different users for different tables/libraries in DB2 for AS400? Please help! Thanks.

ggnanaraj · #2 (**permalink**) 12-30-05, 06:02

Quote:

Originally Posted by tuvarsha

What is the SQL query to retrieve the privileges for different users for different tables/libraries in DB2 for AS400? Please help! Thanks.

You should be able to get this information from a table called sysauth or systabauth. I presume this to be so, as the parallel for syscat.tables (UDB) is systables on AS/400.

However, you need to refer the table with the library name. e.g., dbtest.systables...

HTH.

tuvarsha · #3 (**permalink**) 12-30-05, 11:03

There are no such tables, qsys2.sysauth or qsys2.systabauth in DB2 for AS400. syscat.systabauth is present in DB2 UDB for LUW. There is sysibm.sqltableprivileges as a part of JDBC/ODBC catalogs, but its not working for me. Guess I need to install some fix, but I dont know how. Does anyone know?

Internet Services

Web Development

Digital Marketing

Consumer Tech