GRANT ALL in SQL Server

A GRANT ALL syntax also exists, granting supposedly all the permissions
on a securable. But it is better not to use it, because it does not in fact
grant all permissions, only the ones defined in the SQL-92 ANSI standard.
More permissions are available for SQL Server objects than the permissions
defined in the ANSI standard. The GRANT ALL syntax is now deprecated.

• If the securable is a database, "ALL" means BACKUP DATABASE, BACKUP LOG, CREATE DATABASE, CREATE DEFAULT, CREATE FUNCTION, CREATE PROCEDURE, CREATE RULE, CREATE TABLE, and CREATE VIEW.
• If the securable is a scalar function, "ALL" means EXECUTE and REFERENCES.
• If the securable is a table-valued function, "ALL" means DELETE, INSERT, REFERENCES, SELECT, and UPDATE.
• If the securable is a stored procedure, "ALL" means EXECUTE.
• If the securable is a table, "ALL" means DELETE, INSERT, REFERENCES, SELECT, and UPDATE.
• If the securable is a view, "ALL" means DELETE, INSERT, REFERENCES, SELECT, and UPDATE.