12.6.156. Revoke GRANT ::=
- REVOKE ((<grant type>(<comma> <grant type>)*)?ON ( TABLE <identifier>( CONDITION )? | FUNCTION <identifier> | PROCEDURE <identifier>( CONDITION )? | SCHEMA <identifier> | COLUMN <identifier>( MASK )?))|(ALL PRIVILEGES ) |(TEMP ORARY TABLE ) |(US AGE ON gitops UAGE < identifier >)) FROM <identifier>
ロールの GRANT の取り消し
例:
REVOKE SELECT ON TABLE x.y TO role
REVOKE SELECT ON TABLE x.y TO role