Administration Guide

SYSCAT.SCHEMAAUTH

Contains one or more rows for each user or group who is granted a privilege on a particular schema in the database. All schema privileges for a single schema granted by a specific grantor to a specific grantee appear in a single row.

Table 85. SYSCAT.SCHEMAAUTH Catalog View

Column Name	Data Type	Nullable	Description
GRANTOR	CHAR(8)		Authorization ID of the user who granted the privileges or SYSIBM.
GRANTEE	CHAR(8)		Authorization ID of the user or group who holds the privileges.
GRANTEETYPE	CHAR(1)		U=Grantee is an individual user G=Grantee is a group
SCHEMANAME	CHAR(8)		Name of the schema.
ALTERINAUTH	CHAR(1)		Indicates whether grantee holds ALTERIN privilege on the schema: Y=Privilege is held G=Privilege is held and grantable N=Privilege is not held.
CREATEINAUTH	CHAR(1)		Indicates whether grantee holds CREATEIN privilege on the schema: Y=Privilege is held G=Privilege is held and grantable N=Privilege is not held.
DROPINAUTH	CHAR(1)		Indicates whether grantee holds DROPIN privilege on the schema: Y=Privilege is held G=Privilege is held and grantable N=Privilege is not held.

[ DB2 List of Books | Search the DB2 Books ]