Revoking Grant Authority

From InterBase
Jump to: navigation, search

Go Up to Revoking User Access


To revoke a user’s grant authority for a given privilege, use the following REVOKE syntax:

REVOKE GRANT OPTION FOR privilege [, privilege ] ON table
 FROM user;

For example, the following statement revokes SELECT grant authority on the DEPARTMENTS table from a user, EMIL:

REVOKE GRANT OPTION FOR SELECT ON DEPARTMENTS FROM EMIL;

Advance To: