Account Management Statements information about the differences between static and dynamic privileges, see Static Versus Dynamic Privileges. Table 13.11 Permissible Static Privileges for GRANT and REVOKE Privilege Meaning and Grantable Levels ALL [PRIVILEGES] Grant all privileges at specified access level except GRANT OPTION  and  PROXY . ALTER Enable use of  ALTER TABLE . Levels: Global, database, table. ALTER ROUTINE Enable stored routines to be altered or dropped. Levels: Global, database, routine. CREATE Enable database and table creation. Levels: Global, database, table. CREATE ROLE Enable role creation. Level: Global. CREATE ROUTINE Enable stored routine creation. Levels: Global, database. CREATE TABLESPACE Enable tablespaces and log file groups to be created, altered, or dropped. Level: Global. CREATE TEMPORARY TABLES Enable use of  CREATE TEMPORARY TABLE . Levels: Global, database. CREATE USER Enable use of  CREATE USER ,  DROP USER ,  RENAME USER , and  REVOKE ALL PRIVILEGES . Level: Global. CREATE VIEW Enable views to be created or altered. Levels: Global, database, table. DELETE Enable use of  DELETE . Level: Global, database, table. DROP Enable databases, tables, and views to be dropped. Levels: Global, database, table. DROP ROLE Enable roles to be dropped. Level: Global. EVENT Enable use of events for the Event Scheduler. Levels: Global, database. EXECUTE Enable the user to execute stored routines. Levels: Global, database, routine. FILE Enable the user to cause the server to read or write files. Level: Global. GRANT OPTION Enable privileges to be granted to or removed from other accounts. Levels: Global, database, table, routine, proxy. INDEX Enable indexes to be created or dropped. Levels: Global, database, table. INSERT Enable use of  INSERT . Levels: Global, database, table, column. LOCK TABLES Enable use of  LOCK TABLES  on tables for which you have the  SELECT  privilege. Levels: Global, database. 2867