DB2 Version 9.7 for Linux, UNIX, and Windows

SYSCAT.SCHEMAAUTH catalog view

Each row represents a user, group, or role that has been granted one or more privileges on a schema.

Table 1. SYSCAT.SCHEMAAUTH Catalog View
Column Name Data Type Nullable Description
GRANTOR VARCHAR (128)   Grantor of a privilege.
GRANTORTYPE CHAR (1)  
  • S = Grantor is the system
  • U = Grantor is an individual user
GRANTEE VARCHAR (128)   Holder of a privilege.
GRANTEETYPE CHAR (1)  
  • G = Grantee is a group
  • R = Grantee is a role
  • U = Grantee is an individual user
SCHEMANAME VARCHAR (128)   Name of the schema to which this privilege applies.
ALTERINAUTH CHAR (1)   Privilege to alter or comment on objects in the named schema.
  • G = Held and grantable
  • N = Not held
  • Y = Held
CREATEINAUTH CHAR (1)   Privilege to create objects in the named schema.
  • G = Held and grantable
  • N = Not held
  • Y = Held
DROPINAUTH CHAR (1)   Privilege to drop objects from the named schema.
  • G = Held and grantable
  • N = Not held
  • Y = Held