SQL Language Guide : 8. SQL Statements : REVOKE : Revoking Grant Option
 
Share this page                  
Revoking Grant Option
The GRANT statement GRANT OPTION enables users other than the owner of an object to grant privileges on that object. For example, the following statement enables mike to grant the select privilege (with or without grant option) to other users:
GRANT SELECT ON employee_roster TO mike WITH GRANT OPTION;
The GRANT OPTION can be revoked without revoking the privilege with which it was granted. For example, the following statement:
REVOKE GRANT OPTION FOR SELECT ON employees FROM mike...
means that mike can still select data from the employees table, but cannot grant the select privilege to other users. (The grant option cannot be specified for database privileges.)