SYSCAT.DBAUTH catalog view
Each row represents a user, group, or role that has been granted one or more database-level authorities.
Column Name | Data Type | Nullable | Description |
---|---|---|---|
GRANTOR | VARCHAR (128) | Grantor of the authority. | |
GRANTORTYPE | CHAR (1) |
|
|
GRANTEE | VARCHAR (128) | Holder of the authority. | |
GRANTEETYPE | CHAR (1) |
|
|
BINDADDAUTH | CHAR (1) | Authority to create packages.
|
|
CONNECTAUTH | CHAR (1) | Authority to connect to the database.
|
|
CREATETABAUTH | CHAR (1) | Authority to create tables.
|
|
DBADMAUTH | CHAR (1) | DBADM authority.
|
|
EXTERNALROUTINEAUTH | CHAR (1) | Authority to create external routines.
|
|
IMPLSCHEMAAUTH | CHAR (1) | Authority to implicitly create schemas by creating objects
in non-existent schemas.
|
|
LOADAUTH | CHAR (1) | Authority to use
the Db2® load utility.
|
|
NOFENCEAUTH | CHAR (1) | Authority to create non-fenced user-defined functions.
|
|
QUIESCECONNECTAUTH | CHAR (1) | Authority to access the database when it is quiesced.
|
|
LIBRARYADMAUTH | CHAR (1) | Reserved for future use. | |
SECURITYADMAUTH | CHAR (1) | Authority to administer database security.
|
|
SQLADMAUTH | CHAR (1) | Authority to monitor and tune SQL statements.
|
|
WLMADMAUTH | CHAR (1) | Authority to manage WLM objects.
|
|
EXPLAINAUTH | CHAR (1) | Authority to explain SQL statements without requiring actual
privileges on the objects in the statement.
|
|
DATAACCESSAUTH | CHAR (1) | Authority to access data.
|
|
ACCESSCTRLAUTH | CHAR (1) | Authority to grant and revoke database object privileges.
|
|
CREATESECUREAUTH | CHAR (1) | Authority to create secure objects.
|