Results 1 to 3 of 3
  1. #1
    Join Date
    Dec 2005
    Posts
    39

    Unanswered: DB2 AS400 privileges

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

  2. #2
    Join Date
    Aug 2002
    Location
    Chennai, India
    Posts
    184
    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.

  3. #3
    Join Date
    Dec 2005
    Posts
    39
    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?

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •