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 Distinct Type |
---|---|
ALL (Grant or revoke of ALL grants or revokes only those privileges the authorization ID of the statement has) |
*OBJALTER *OBJOPR *EXECUTE *OBJMGT (Revoke only) |
ALTER | *OBJALTER |
USAGE |
*EXECUTE *OBJOPR |
WITH GRANT OPTION | *OBJMGT |
Corresponding System Authorities When Checking Privileges to a Distinct Type: The following table describes the system authorities that correspond to the SQL privileges when checking privileges to a distinct type. The left column lists the SQL privilege. The right column lists the equivalent system authorities.
SQL Privilege | Corresponding System Authorities when Granting to or Revoking from a Distinct Type |
---|---|
ALTER | *OBJALTER |
USAGE |
*EXECUTE and *OBJOPR |
When USAGE privilege is required: USAGE privilege is required when a distinct type is explicitly referenced in an SQL statement. For example, in a statement that contains a CAST specification or in a CREATE TABLE statement. The USAGE privilege is not required when a distinct type is indirectly referenced. For example, when a view references a column of a table that has a distinct data type.
Syntax alternatives: The following keywords are synonyms supported for compatibility to prior releases. These keywords are non-standard and should not be used:
(C) Copyright IBM Corporation 1992, 2006. All Rights Reserved.