9. Extended Statements : Revoke : Revoking the Grant Option
 
Share this page                  
Revoking the Grant Option
The GRANT statement GRANT OPTION enables users other than the owner of an object to grant privileges on that object. For example:
grant select on employee_roster to mike with grant 
option;
enables mike to grant the select privilege (with or without GRANT OPTION) to other users.
The GRANT option can be revoked without revoking the privilege with which it was granted. For example:
revoke grant option for select on employees to 
mike...
means that mike can still select data from the employees table, but cannot grant the select privilege to other users.