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:
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.
SQL Privilege | Corresponding System Authorities |
---|---|
ALTER | *OBJALTER |
USAGE |
*OBJOPR and *EXECUTE and *READ and *ADD and *DLT and *UPD |
(C) Copyright IBM Corporation 1992, 2006. All Rights Reserved.