Granting Users the Right to Grant Privileges
Go Up to Planning Security
Initially, only the owner of a table or view can grant access privileges on the object to other users. The WITH GRANT OPTION clause transfers the right to grant privileges to other users.
To assign grant authority to another user, add the WITH GRANT OPTION clause to the end of a GRANT statement.
The following statement assigns SELECT access to user EMIL and allows EMIL to grant SELECT access to other users:
GRANT SELECT ON DEPARTMENTS TO EMIL WITH GRANT OPTION;
- Note: You cannot assign the
WITH GRANT OPTIONto a stored procedure.
WITH GRANT OPTION clauses are cumulative, even if issued by different users. For example, EMIL can be given grant authority for SELECT by one user, and grant authority for INSERT by another user. For more information about cumulative privileges, see Grant Authority Implications.