Privileges Provided by MySQL •Privileges for database objects such as tables, indexes, views, and stored routines can be granted for specific objects within a database, for all objects of a given type within a database (for example, all tables in a database), or globally for all objects of a given type in all databases. Privileges also differ in terms of whether they are static (built in to the server) or dynamic (defined at runtime). Whether a privilege is static or dynamic affects its availability to be granted to user accounts and roles. For information about the differences between static and dynamic privileges, see Static Versus Dynamic Privileges.) Information about account privileges is stored in the grant tables in the  mysql  system database. For a description of the structure and contents of these tables, see Section 6.2.3, “Grant Tables” . The MySQL server reads the contents of the grant tables into memory when it starts, and reloads them under the circumstances indicated in Section 6.2.13, “When Privilege Changes Take Effect” . The server bases access-control decisions on the in-memory copies of the grant tables. Some MySQL releases introduce changes to the grant tables to add new privileges or features. To make sure that you can take advantage of any new capabilities, update your grant tables to the current structure whenever you upgrade MySQL. See Section 2.11, “Upgrading MySQL” . The following sections summarize the available privileges, provide more detailed descriptions of each privilege, and offer usage guidelines. The following table shows the static privilege names used in  GRANT  and  REVOKE  statements, along with the column name associated with each privilege in the grant tables and the context in which the privilege applies. •Summary of Available Privileges •Static Privilege Descriptions •Dynamic Privilege Descriptions •Privilege-Granting Guidelines •Static Versus Dynamic Privileges •Migrating Accounts from SUPER to Dynamic Privileges Important Summary of Available Privileges Table 6.2 Permissible Static Privileges for GRANT and REVOKE Privilege Grant Table Column Context ALL [PRIVILEGES] Synonym for “all privileges” Server administration ALTER Alter_priv Tables ALTER ROUTINE Alter_routine_priv Stored routines CREATE Create_priv Databases, tables, or indexes CREATE ROLE Create_role_priv Server administration CREATE ROUTINE Create_routine_priv Stored routines CREATE TABLESPACE Create_tablespace_priv Server administration CREATE TEMPORARY TABLES Create_tmp_table_priv Tables 1187