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
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.