## Grant Table Overview 

•The proxies_priv Grant Table 

•The global_grants Grant Table 

•The default_roles Grant Table 

•The role_edges Grant Table 

•The password_history Grant Table 

•Grant Table Scope Column Properties 

•Grant Table Privilege Column Properties 

•Grant Table Concurrency 

These mysql  database tables contain grant information: 

• user : User accounts, static global privileges, and other nonprivilege columns. 

• global_grants : Dynamic global privileges. 

• db : Database-level privileges. 

• tables_priv : Table-level privileges. 

• columns_priv : Column-level privileges. 

• procs_priv : Stored procedure and function privileges. 

• proxies_priv : Proxy-user privileges. 

• default_roles : Default user roles. 

• role_edges : Edges for role subgraphs. 

• password_history : Password change history. 

For information about the differences between static and dynamic global privileges, see Static Versus Dynamic Privileges.) 

In MySQL 8.0, grant tables use the InnoDB  storage engine and are transactional. Before MySQL 8.0, grant tables used the MyISAM  storage engine and were nontransactional. This change of grant table storage engine enables an accompanying change to the behavior of account-management statements such as CREATE USER  or GRANT . Previously, an account-management statement that named multiple users could succeed for some users and fail for others. Now, each statement is transactional and either succeeds for all named users or rolls back and has no effect if any error occurs. 

Each grant table contains scope columns and privilege columns: 

•Scope columns determine the scope of each row in the tables; that is, the context in which the row applies. For example, a user  table row with Host  and User  values of ’h1.example.net’  and ’bob’  applies to authenticating connections made to the server from the host h1.example.net  by a client that specifies a user name of bob . Similarly, a db  table row with Host , User , and Db  column values of ’h1.example.net’ , ’bob’  and ’reports’  applies when bob  connects from the host h1.example.net  to access the reports  database. The tables_priv  and columns_priv  tables 

