Granting Users the Right to Grant Privileges

From InterBase
Jump to: navigation, search

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

Topics

Advance To: