| Nome da coluna |
Tipo do dado |
Descrição |
Uso |
| GRANTOR |
CHAR(8) NOT NULL |
Authorization ID of the user who granted the privileges. |
G |
| GRANTEE |
CHAR(8) NOT NULL |
Authorization ID of the user that holds the privilege. Could also be PUBLIC for a grant
to PUBLIC. |
G |
| |
CHAR(12) NOT NULL |
Internal use only |
I |
| DATEGRANTED |
CHAR(6) NOT NULL |
Date the privileges were granted; in the form yymmdd. |
G |
| TIMEGRANTED |
CHAR(8) NOT NULL |
Time the privileges were granted; in the form hhmmssth. |
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.
blank Not applicable
C DBCTL
D DBADM
L SYSCTRL
M DBMAINT
S SYSADM
|
G |
| |
CHAR(1) NOT NULL |
Not used |
N |
| BINDADDAUTH |
CHAR(8) NOT NULL |
Whether the GRANTEE can use the BIND subcommand with the ADD option:
blank Privilege is not held
G
Privilege is held with the GRANT option
Y
Privilege is held without the GRANT option
|
G |
| BSDSAUTH |
CHAR(1) NOT NULL |
Whether the GRANTEE can issue the RECOVER BSDS command:
blank Privilege is not held
G
Privilege is held with the GRANT option
Y
Privilege is held without the GRANT option |
G |
| CREATEDBAAUTH |
CHAR(1) NOT NULL |
Whether the GRANTEE can create databases and automatically receive DBADM authority over the new databases:
blank Privilege is not held
G
Privilege is held with the GRANT option
Y
Privilege is held without the GRANT option |
G |
| CREATEDBCAUTH |
CHAR(1) NOT NULL |
Whether the GRANTEE can execute the CREATE DATABASE statement to create new
databases and automatically receive DBCTRL automatically receive DBCTRLauthority
over the new databases:
blank Privilege is not held
G
Privilege is held with the GRANT option
Y
Privilege is held without the GRANT option |
G |
| DISPLAYAUTH |
CHAR(1) NOT NULL |
Whether the GRANTEE can use the DISPLAY commands:
blank Privilege is not held
G
Privilege is held with the GRANT option
Y
Privilege is held without the GRANT option |
G |
| RECOVERAUTH |
CHAR(1) NOT NULL |
Whether the GRANTEE can use the RECOVER INDOUBT command:
blank Privilege is not held
G
Privilege is held with the GRANT option
Y
Privilege is held without the GRANT option |
G |
| STOPALLAUTH |
CHAR(1) NOT NULL |
Whether the GRANTEE can use the STOP command:
blank Privilege is not held
G
Privilege is held with the GRANT option
Y
Privilege is held without the GRANT option |
G |
| STOSPACEAUTH |
CHAR(1) NOT NULL |
Whether the GRANTEE can use the STOSPACE utility:
blank Privilege is not held
G
Privilege is held with the GRANT option
Y
Privilege is held without the GRANT option |
G |
| SYSADMAUTH |
CHAR(1) NOT NULL |
Whether the GRANTEE has system administration authority:
blank Privilege is not held
G
Privilege was granted with the GRANT option
Y
Privilege was granted without the GRANT option
GRANTEE has the privilege with the GRANT option for a value of either Y or G. |
G |
| SYSOPRAUTH |
CHAR(1) NOT NULL |
Whether the GRANTEE has system operator authority:
blank Privilege is not held
G
Privilege is held with the GRANT option
Y
Privilege is held without the GRANT option |
G |
| TRACEAUTH |
CHAR(1) NOT NULL |
Whether the GRANTEE can issue the START TRACE and STOP TRACE commands:
blank Privilege is not held
G
Privilege is held with the GRANT option
Y
Privilege is held without the GRANT option |
G |
| IBMREQD |
CHAR(1) NOT NULL |
Whether the row came from the basic machine-readable material (MRM) tape:
N No
Y Yes
|
G |
| MON1AUTH |
CHAR(1) NOT NULL
WITH DEFAULT |
Whether the GRANTEE can obtain IFC serviceability data.
blank Privilege is not held
G
Privilege is held with the GRANT option
Y
Privilege is held without the GRANT option |
G |
| MON2AUTH |
CHAR(1) NOT NULL
WITH DEFAULT |
Whether the GRANTEE can obtain IFC data.
blank Privilege is not held
G
Privilege is held with the GRANT option
Y
Privilege is held without the GRANT option |
G |
| CREATEALIASAUTH |
CHAR(1) NOT NULL
WITH DEFAULT |
Whether the GRANTEE can execute the CREATE ALIAS statement.
blank Privilege is not held
G
Privilege is held with the GRANT option
Y
Privilege is held without the GRANT option |
G |
| SYSCTRLAUTH |
CHAR(1) NOT NULL
WITH DEFAULT |
Whether the GRANTEE has SYSCTRL authority:
blank Privilege is not held
G
Privilege is held with the GRANT option
Y
Privilege is held without the GRANT option
GRANTEE has the privilege with the GRANT option for a value of either Y or G. |
G |
| BINDAGENTAUTH |
CHAR(1) NOT NULL
WITH DEFAULT |
Whether the GRANTEE has BINDAGENT privilege:
blank Privilege is not held
G
Privilege is held with the GRANT option
Y
Privilege is held without the GRANT option |
G |
| ARCHIVEAUTH |
CHAR(1) NOT NULL
WITH DEFAULT |
Whether the GRANTEE is privileged to use the ARCHIVE LOG command:
blank Privilege is not held
G
Privilege is held with the GRANT option
Y
Privilege is held without the GRANT option |
G |
| |
CHAR(1) NOT NULL
WITH DEFAULT |
Not used |
N |
| |
CHAR(1) NOT NULL
WITH DEFAULT |
Not used |
N |
| GRANTEDTS |
TIMESTAMP NOT NULL
WITH DEFAULT |
Time when the GRANT statement was executed. The value is
'1985-04-01.00.00.00.000000' for the one installation row. |
G |
| CREATETMTABAUTH |
CHAR(1) NOT NULL
WITH DEFAULT |
Whether the GRANTEE has CREATETMTABAUTH privilege:
blank Privilege is not held
G
Privilege is held with the GRANT option
Y
Privilege is held without the GRANT option |
G |
