content_image/775183.jpg
<img src='content_image/775183.jpg'>

The Routine_type  column is an ENUM  column with values of ’FUNCTION’  or ’PROCEDURE’  to indicate the type of routine the row refers to. This column enables privileges to be granted separately for a function and a procedure with the same name. 

## The proxies_priv Grant Table 

The Timestamp  and Grantor  columns are unused. 

The proxies_priv  table records information about proxy accounts. It has these columns: 

• Host , User : The proxy account; that is, the account that has the PROXY  privilege for the proxied account. 

• Proxied_host , Proxied_user : The proxied account. 

• Grantor , Timestamp : Unused. 

• With_grant : Whether the proxy account can grant the PROXY  privilege to other accounts. 

For an account to be able to grant the PROXY  privilege to other accounts, it must have a row in the proxies_priv  table with With_grant  set to 1 and Proxied_host  and Proxied_user  set to indicate the account or accounts for which the privilege can be granted. For example, the ’root’@’localhost’ account created during MySQL installation has a row in the proxies_priv  table that enables granting the PROXY  privilege for ’’@’’ , that is, for all users and all hosts. This enables root  to set up proxy users, as well as to delegate to other accounts the authority to set up proxy users. See Section 6.2.18, “Proxy Users” . 

## The global_grants Grant Table 

The global_grants  table lists current assignments of dynamic global privileges to user accounts. The table has these columns: 

• USER , HOST : The user name and host name of the account to which the privilege is granted. 

• PRIV : The privilege name. 

• WITH_GRANT_OPTION : Whether the account can grant the privilege to other accounts. 

## The default_roles Grant Table 

The default_roles  table lists default user roles. It has these columns: 

