Revoking Grant Authority

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:

• Using Views to Restrict Data Access