Grant Tables Table 6.7 procs_priv Table Columns Table Name procs_priv Scope columns Host Db User Routine_name Routine_type Privilege columns Proc_priv Other columns Timestamp Grantor The proxies_priv Grant Table The global_grants Grant Table The default_roles Grant Table • WITH_GRANT_OPTION : Whether the account can grant the privilege to other accounts. • PRIV : The privilege name. • USER ,  HOST : The user name and host name of the account to which the privilege is granted. The  default_roles  table lists default user roles. It has these columns: The  global_grants  table lists current assignments of dynamic global privileges to user accounts. The table has these columns: 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  proxies_priv  table records information about proxy accounts. It has these columns: The  Timestamp  and  Grantor  columns are unused. 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. • 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. 1211