Granting all Privileges
From InterBase
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;