SYSCAT.SEQUENCEAUTH catalog view

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

Table 1. SYSCAT.SEQUENCEAUTH 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
SEQSCHEMA VARCHAR (128)   Schema name of the sequence.
SEQNAME VARCHAR (128)   Unqualified name of the sequence.
ALTERAUTH CHAR (1)   Privilege to alter the sequence.
  • G = Held and grantable
  • N = Not held
  • Y = Held
USAGEAUTH CHAR (1)   Privilege to reference the sequence.
  • G = Held and grantable
  • N = Not held
  • Y = Held
GRANT_TIME TIMESTAMP   Time at which the privilege was granted.
GRANTREVOKE_TIME TIMESTAMP   Time at which a privilege was last granted or revoked.