REPLACE(mvc.Column_priv, ',', ', ') AS `Privileges`ĬONCAT(mp.Db, '.', mp.Routine_name) `Procedures`,

the list of privileges for view columns:ĬONCAT(mvc.Db, '.', mvc.Table_name, '.', mvc.Column_name) `Views Columns`,.

REPLACE(mtc.Column_priv, ',', ', ') AS `Privileges`

the list of privileges for table columns:ĬONCAT(mtc.Db, '.', mtc.Table_name, '.', mtc.Column_name) `Tables Columns`,.REPLACE(mv.Table_priv, ',', ', ') AS `Privileges` ('BASE TABLE', 'SYSTEM VIEW', 'TEMPORARY', '') ORĬONCAT(mv.Db, '.', mv.Table_name) `Views`, REPLACE(mt.Table_priv, ',', ', ') AS `Privileges` IF(md.Alter_routine_priv = 'Y', 'Alter_routine ', ''), IF(md.Create_view_priv = 'Y', 'Create_view ', ''), IF(md.Lock_tables_priv = 'Y', 'Lock_tables ', ''), IF(md.Create_tmp_table_priv = 'Y', 'Create_tmp_table ', ''), IF(md.References_priv = 'Y', 'References ', ''), IF(mu.Trigger_priv = 'Y', 'Trigger ', '') IF(mu.Create_user_priv = 'Y', 'Create_user ', ''), IF(mu.Alter_routine_priv = 'Y', 'Alter_routine ', ''), IF(mu.Create_routine_priv = 'Y', 'Create_routine ', ''), IF(mu.Create_view_priv = 'Y', 'Create_view ', ''), IF(mu.Repl_client_priv = 'Y', 'Repl_client ', ''), IF(mu.Lock_tables_priv = 'Y', 'Lock_tables ', ''), IF(mu.Create_tmp_table_priv = 'Y', 'Create_tmp_table ', ''), IF(mu.References_priv = 'Y', 'References ', ''), IF(mu.Shutdown_priv = 'Y', 'Shutdown ', ''), To get the list of users’ privileges concerning data access, the following queries may be executed: procs_priv contains a list of database procedures (functions) a user has access to.columns_priv contains a list of columns from the database tables (views) a user has access to.tables_priv contains a list of database tables (views) that a user has access to.db contains a list of databases with a matching list of database users and their privileges for executing operations.

user contains a list of all users of the MySQL server and their permissions to access the database.

There are tables for storing information about users’ accounts in this database: The database that MySQL server uses to store internal data about users is called mysql by default. The access policy is based on the values available in these tables. MySQL server uses several tables in a special database to organize such a complicated database access structure. Also, there is a restriction for actions a user may perform with records. A database user can have access to the whole database, separate tables, or to separate columns of tables. MySQL has an advanced database access system.

Get users mysql