Note

Corresponding System Authorities: GRANT and REVOKE statements assign and remove system authorities for SQL objects. The following table describes the system authorities that correspond to the SQL privileges:

Table 68. Privileges Granted to or Revoked from Sequences
SQL Privilege Corresponding System Authorities when Granting to or Revoking from a Sequence
ALL (Grant or revoke of ALL grants or revokes only those privileges the authorization ID of the statement has)
*OBJALTER
*OBJOPR
*EXECUTE
*READ
*ADD
*DLT
*UPD
*OBJMGT (Revoke only)
ALTER *OBJALTER
USAGE
*OBJOPR
*EXECUTE
*READ
*ADD
*DLT
*UPD
WITH GRANT OPTION *OBJMGT

Corresponding System Authorities When Checking Privileges to a Sequence: The following table describes the system authorities that correspond to the SQL privileges when checking privileges to a sequence. The left column lists the SQL privilege. The right column lists the equivalent system authorities.

Table 69. Corresponding System Authorities When Checking Privileges to a Sequence
SQL Privilege Corresponding System Authorities
ALTER *OBJALTER
USAGE
*OBJOPR and *EXECUTE and
*READ and *ADD and
*DLT and *UPD