SYSCAT.TABAUTH catalog view
Each row represents a user, group, or role that has been granted one or more privileges on a table, view or nickname.
Column Name | Data Type | Nullable | Description |
---|---|---|---|
GRANTOR | VARCHAR (128) | Grantor of the privilege. | |
GRANTORTYPE | CHAR (1) |
|
|
GRANTEE | VARCHAR (128) | Holder of the privilege. | |
GRANTEETYPE | CHAR (1) |
|
|
TABSCHEMA | VARCHAR (128) | Schema name of the table or view. | |
TABNAME | VARCHAR (128) | Unqualified name of the table or view. | |
CONTROLAUTH | CHAR (1) | CONTROL privilege.
|
|
ALTERAUTH | CHAR (1) | Privilege to alter the table; allow a parent table to this
table to drop its primary key or unique constraint; allow a table
to become a materialized query table that references this table or
view in the materialized query; or allow a table that references
this table or view in its materialized query to no longer be a materialized
query table.
|
|
DELETEAUTH | CHAR (1) | Privilege to delete rows from a table or updatable view.
|
|
INDEXAUTH | CHAR (1) | Privilege to create an index on a table.
|
|
INSERTAUTH | CHAR (1) | Privilege to insert rows into a table or updatable view, or
to run the import utility against a table or view.
|
|
REFAUTH | CHAR (1) | Privilege to create and drop a foreign key referencing a table
as the parent.
|
|
SELECTAUTH | CHAR (1) | Privilege to retrieve rows from a table or view, create views
on a table, or to run the export utility against a table or view.
|
|
UPDATEAUTH | CHAR (1) | Privilege to run the UPDATE statement against a table or updatable
view.
|