Granting all Privileges

From InterBase
Jump to: navigation, search

Go Up to Multiple Privileges and Multiple Grantees


The ALL privilege combines the SELECT, DELETE, INSERT, UPDATE, and REFERENCESprivileges for a table in a single expression. It is a shorthand way to assign that group of privileges to a user or procedure. For example, the following statement grants all access privileges for the DEPARTMENTS table to a user, SUSAN:

GRANT ALL ON DEPARTMENTS TO SUSAN;

SUSAN can now perform SELECT, DELETE, INSERT, UPDATE, and REFERENCES operations on the DEPARTMENTS table.

Procedures can be assigned ALL privileges. When a procedure is assigned privileges, the PROCEDURE keyword must precede its name. For example, the following statement grants all privileges for the ACCOUNTS table to the procedure, MONEY_TRANSFER:

GRANT ALL ON ACCOUNTS TO PROCEDURE MONEY_TRANSFER;

Advance To: