DB2 zOS

SYSIBM.SYSSCHEMAAUTH (V8)

Description: Contains one or more rows for each user that is granted a privilege on a particular schema in the database.

Tablespace: SYSOBJ

Indexes(Fields):
DSNSKX01(GRANTEE.SCHEMANAME)
DSNSKX02(GRANTOR)

Column name	Description	Data type
GRANTOR	Authorization ID of the user who granted the privileges or SYSADM.	NOT NULL
GRANTEE	Authorization ID of the user or group who holds the privileges. Can also be PUBLIC for a grant to PUBLIC.	NOT NULL
SCHEMANAME	Name of the schema or '*' for all schemas.	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. This field is also used to indicate that the privilege was held on all schemas by the grantor. 1 Grantor had privilege on all schemas at time of grant L SYSCTRL S SYSADM	NOT NULL
CREATEINAUTH	Indicates whether grantee holds CREATEIN privilege on the schema: ; blank Privilege is not held G Privilege is held with the GRANT option Y Privilege is held without the GRANT option	NOT NULL
ALTERINAUTH	Indicates whether grantee holds ALTERIN privilege on the schema: ; blank Privilege is not held G Privilege is held with the GRANT option Y Privilege is held without the GRANT option	NOT NULL
DROPINAUTH	Indicates whether grantee holds DROPIN privilege on the schema: ; blank Privilege is not held G Privilege is held with the GRANT option Y Privilege is held without the GRANT option	NOT NULL
GRANTEDTS	Time when the GRANT statement was executed.	NOT NULL
IBMREQD	A value of Y indicates that the row came from the basic machine-readable material (MRM) tape.	NOT NULL

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

DBPedias