SQL Reference

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 84. SYSCAT.SCHEMAAUTH Catalog View
Column Name Data Type Nullable Description
GRANTOR VARCHAR(128)
Authorization ID of the user who granted the privileges or SYSIBM.
GRANTEE VARCHAR(128)
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 VARCHAR(128)
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.


[ Top of Page | Previous Page | Next Page ]