Use SELECT statements to retrieve data from the user, tables_priv, and columns_priv tables : Permission « User Permission « SQL / MySQL






  1. SQL / MySQL
  2. User Permission
  3. Permission

Use SELECT statements to retrieve data from the user, tables_priv, and columns_priv tables

      


SELECT host, user, select_priv, update_priv FROM user WHERE user='user1';

SELECT host, db, user, table_name, table_priv, column_priv
FROM tables_priv WHERE user='user1';

SELECT host, db, user, table_name, column_name, column_priv
FROM columns_priv WHERE user='user1';








Related examples in the same category

1.Show Permission
2.Use SELECT statements to see how the user account would be added to the user and db tables