The SQLTABLEPRIVILEGES view contains one row for every privilege granted on a table. 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 view:
| Column Name | Data Type | Description |
|---|---|---|
| TABLE_CAT | VARCHAR(128) | Relational database name |
| TABLE_SCHEM | VARCHAR(128) | Name of the SQL schema of the table. |
| TABLE_NAME | VARCHAR(128) | Name of the table. |
| GRANTOR | VARCHAR(128) Nullable |
Reserved. Contains the null value. |
| GRANTEE | VARCHAR(128) | The user profile to which the privilege is granted. |
| PRIVILEGE | VARCHAR(10) | The privilege granted:
|
| IS_GRANTABLE | VARCHAR(3) | Indicates whether the privilege is grantable to other users.
|
| DBNAME | VARCHAR(8) Nullable |
Reserved. Contains the null value. |