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.
Last modified date: 01/30/2023