SYSIBM.SYSDBAUTH table
The SYSIBM.SYSDBAUTH table records the privileges that are held by users over databases.
Column name | Data type | Description | Use |
---|---|---|---|
GRANTOR | VARCHAR(128)
NOT NULL |
Authorization ID or role of the user who granted the privileges. Could also be PUBLIC. | G |
GRANTEE | VARCHAR(128)
NOT NULL |
Application ID of the user who holds the privilege. Could also be PUBLIC for a grant to PUBLIC. | G |
NAME | VARCHAR(24)
NOT NULL |
Database name. | G |
CHAR(12)
NOT NULL |
Internal use only | I | |
CHAR(6)
NOT NULL |
Not used | N | |
CHAR(8)
NOT NULL |
Not used | N | |
GRANTEETYPE | CHAR(1)
NOT NULL WITH DEFAULT |
Indicates the type of grantee:
|
G |
CHAR(1)
NOT NULL |
Not used | N | |
AUTHHOWGOT | CHAR(1)
NOT NULL |
Authorization level of the user from whom the privileges
were received. This authorization level is not necessarily the highest
authorization level of the grantor.
|
G |
CREATETABAUTH | CHAR(1)
NOT NULL |
Whether the GRANTEE can create tables within the
database:
|
G |
CREATETSAUTH | CHAR(1)
NOT NULL |
Whether the GRANTEE can create table spaces within
the database:
|
G |
DBADMAUTH | CHAR(1)
NOT NULL |
Whether the GRANTEE has DBADM authority over the
database:
|
G |
DBCTRLAUTH | CHAR(1)
NOT NULL |
Whether the GRANTEE has DBCTRL authority over the
database:
|
G |
DBMAINTAUTH | CHAR(1)
NOT NULL |
Whether the GRANTEE has DBMAINT authority over
the database:
|
G |
DISPLAYDBAUTH | CHAR(1)
NOT NULL |
Whether the GRANTEE can issue the DISPLAY command
for the database:
|
G |
DROPAUTH | CHAR(1)
NOT NULL |
Whether the GRANTEE can issue the ALTER DATABASE
and DROP DATABASE statement:
|
G |
IMAGCOPYAUTH | CHAR(1)
NOT NULL |
Whether the GRANTEE can use the COPY, MERGECOPY,
MODIFY, and QUIESCE utilities on the database:
|
G |
LOADAUTH | CHAR(1)
NOT NULL |
Whether the GRANTEE can use the LOAD utility to
load tables in the database:
|
G |
REORGAUTH | CHAR(1)
NOT NULL |
Whether the GRANTEE can use the REORG utility to
reorganize table spaces and indexes in the database:
|
G |
RECOVERDBAUTH | CHAR(1)
NOT NULL |
Whether the GRANTEE can use the RECOVER and REPORT
utilities on table spaces in the database:
|
G |
REPAIRAUTH | CHAR(1)
NOT NULL |
Whether the GRANTEE can use the DIAGNOSE and REPAIR
utilities on table spaces and indexes in the database:
|
G |
STARTDBAUTH | CHAR(1)
NOT NULL |
Whether the GRANTEE can use the START command against
the database:
|
G |
STATSAUTH | CHAR(1)
NOT NULL |
Whether the GRANTEE can use the CHECK and RUNSTATS
utilities against the database:
|
G |
STOPAUTH | CHAR(1)
NOT NULL |
Whether the GRANTEE can issue the STOP command
against the database:
|
G |
IBMREQD | CHAR(1)
NOT NULL |
A value of Y indicates that the row came from the basic machine-readable material
(MRM) tape. For all other values, see Release dependency
indicators. The value in this field is not a reliable indicator of release dependencies. |
G |
GRANTEDTS | TIMESTAMP
NOT NULL WITH DEFAULT |
Time when the GRANT statement was executed. | G |
GRANTORTYPE | CHAR(1)
NOT NULL WITH DEFAULT |
Indicates the type of grantor:
|
G |