SYSTABAUTH

The SYSTABAUTH view contains one row for every privilege granted on a table or view. Note that this catalog view cannot be used to determine whether a user is authorized to a table or view because the privilege to use a table or view could be acquired through a group user profile or special authority (such as *ALLOBJ).

The following table describes the columns in the SYSTABAUTH view:

Table 1. SYSTABAUTH view
Column Name System Column Name Data Type Description
GRANTOR GRANTOR VARCHAR(128)
Nullable
 Reserved. Contains the null value.
GRANTEE GRANTEE VARCHAR(128) The user profile to which the privilege is granted.
TABLE_SCHEMA DBNAME VARCHAR(128) Name of the schema
TABLE_NAME NAME VARCHAR(128) Name of the table
PRIVILEGE_TYPE PRIVTYPE VARCHAR(10) The privilege granted:
ALTER
The privilege to alter the table.
DELETE
The privilege to delete rows from the table.
INDEX
The privilege to create an index on the table.
INSERT
The privilege to insert rows into the table.
REFERENCES
The privilege to reference the table in a referential constraint.
SELECT
The privilege to select rows from the table.
UPDATE
The privilege to update the table.
IS_GRANTABLE GRANTABLE VARCHAR(3) Indicates whether the privilege is grantable to other users.
NO
The privilege is not grantable.
YES
The privilege is grantable.
AUTHORIZATION_LIST AUTL VARCHAR(10)
Nullable
 If the privilege is granted through an authorization, contains the name of the authorization list.

Contains the null value if the privilege is not granted through an authorization list.
SYSTEM_TABLE_SCHEMA SYS_DNAME CHAR(10) System name of the schema
SYSTEM_TABLE_NAME SYS_TNAME CHAR(10) System name of the table or view