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
SELECTINAUTH CHAR (1)  

Implicit privilege to select all of the existing and future tables or views defined in the schema.

Implicit SELECT privilege on all of the existing and future tables or views defined in the schema.

  • G = Held and grantable
  • N = Not held
  • Y = Held
INSERTINAUTH CHAR (1)  

Implicit privilege to insert on all of the existing and future tables or updatable views defined in the schema.

Implicit INSERT privilege on all of the existing and future tables or updatable views defined in the schema.

  • G = Held and grantable
  • N = Not held
  • Y = Held
UPDATEINAUTH CHAR (1)  

Implicit privilege to update all of the existing and future tables or updatable views defined in the schema.

Implicit UPDATE privilege on all of the existing and future tables or updatable views defined in the schema.

  • G = Held and grantable
  • N = Not held
  • Y = Held
DELETEINAUTH CHAR (1)  

Implicit privilege to delete all of the existing and future tables or updatable views defined in the schema.

Implicit DELETE privilege on all of the existing and future tables or updatable views defined in the schema.

  • G = Held and grantable
  • N = Not held
  • Y = Held
EXECUTEINAUTH CHAR (1)  

Implicit privilege to execute on all of the existing and future routines, packages and module objects defined in the schema.

Implicit EXECUTE privilege on all of the existing and future routines, packages and module objects defined in the schema

  • G = Held and grantable
  • N = Not held
  • Y = Held
SCHEMAADMAUTH CHAR (1)   SCHEMAADM authority.
  • N = Not held
  • Y = Held
ACCESSCTRLAUTH CHAR (1)   Schema ACCESSCTRL authority to grant and revoke schema object privileges.
  • N = Not held
  • Y = Held
DATAACCESSAUTH CHAR (1)   Schema DATAACCESS authority to access data.
  • N = Not held
  • Y = Held
LOADAUTH CHAR (1)   Schema LOAD authority to use the load utility.
  • N = Not held
  • Y = Held