tables_priv And columns_priv Tablestables_priv and columns_priv tables for requests that involve tables.
tables_priv and columns_priv tables provide finer privilege control at the table and column levels.
| Table Name | tables_priv | columns_priv |
|---|---|---|
| Scope columns | Host |
Host |
Db |
Db |
|
User |
User |
|
Table_name |
Table_name |
|
Column_name |
||
| Privilege columns | Table_priv |
Column_priv |
Column_priv |
||
| Other columns | Timestamp |
Timestamp |
Grantor |
What does the procs_priv table look like?
© 2007 John Michael Pierobon