Retrieving catalog information about authorizations

The SYSIBM.SYSTABAUTH table contains information about who can access your data.

Procedure

To obtain information about who can access your data:

Begin general-use programming interface information.

Query the SYSIBM.SYSTABAUTH table.

The following query retrieves the names of all users who have been granted access to the DSN8C10.DEPT table.

SELECT GRANTEE
  FROM SYSIBM.SYSTABAUTH
  WHERE TTNAME = 'DEPT'
    AND GRANTEETYPE <> 'P'
    AND TCREATOR = 'DSN8C10';

GRANTEE is the name of the column that contains authorization IDs for users of tables. The TTNAME and TCREATOR columns specify the DSN8C10.DEPT table. The clause GRANTEETYPE <> 'P' ensures that you retrieve the names only of users (not application plans or packages) that have authority to access the table.

End general-use programming interface information.