SYSIBM.SYSUSERAUTH (V8) | DB2 zOS wiki on DBPedias | All your database are belong to you

Description: Records the system privileges that are held by users.

Tablespace: SYSUSER

Indexes(Fields):
DSNAUH01(GRANTEE GRANTEDTS)
DSNAUX02(GRANTOR)

Column name	Description	Data type
GRANTOR	Authorization ID of the user who granted the privileges.	NOT NULL
GRANTEE	Authorization ID of the user that holds the privilege. Could also be PUBLIC for a grant to PUBLIC.	NOT NULL
	Internal use only	NOT NULL
	Not used	NOT NULL
	Not used	NOT NULL
	Not used	NOT NULL
AUTHHOWGOT	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 O SYSOPR S SYSADM	NOT NULL
	Not used	NOT NULL
BINDADDAUTH	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	NOT NULL
BSDSAUTH	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	NOT NULL
CREATEDBAAUTH	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	NOT NULL
CREATEDBCAUTH	Whether the GRANTEE can execute the CREATE DATABASE statement to create new databases and automatically receive DBCTRL 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	NOT NULL
CREATESGAUTH	Whether the GRANTEE can execute the CREATE STOGROUP statement to create new storage groups: ; blank Privilege is not held G Privilege is held with the GRANT option Y Privilege is held without the GRANT option	NOT NULL
DISPLAYAUTH	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	NOT NULL
RECOVERAUTH	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	NOT NULL
STOPALLAUTH	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	NOT NULL
STOSPACEAUTH	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	NOT NULL
SYSADMAUTH	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.	NOT NULL
SYSOPRAUTH	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	NOT NULL
TRACEAUTH	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	NOT NULL
IBMREQD	A value of Y indicates that the row came from the basic machine-readable material (MRM) tape.	NOT NULL
MON1AUTH	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	NOT NULL WITH DEFAULT
MON2AUTH	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	NOT NULL WITH DEFAULT
CREATEALIASAUTH	Whether the GRANTEE can execute the CREATE ALIAS statement: ; blank Privilege is not held G Privilege held with the GRANT option Y Privilege held without the GRANT option	NOT NULL WITH DEFAULT
SYSCTRLAUTH	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.	NOT NULL WITH DEFAULT
BINDAGENTAUTH	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	NOT NULL WITH DEFAULT
ARCHIVEAUTH	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	NOT NULL WITH DEFAULT
	Not used	NOT NULL WITH DEFAULT
	Not used	NOT NULL WITH DEFAULT
GRANTEDTS	Time when the GRANT statement was executed. The value is '1985-04-01.00.00.00.000000' for the one installation row.	NOT NULL WITH DEFAULT
CREATETMTABAUTH	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	NOT NULL WITH DEFAULT

Adapted from material found in the IBM DB2 Universal Database for z/OS V8 SQL Reference (SC18-7426-02).

Retrieved from "http://dbpedias.com/w/index.php?title=DB2_zOS:SYSIBM.SYSUSERAUTH_(V8)&oldid=22064"