Check out the privilege for a user : SQL Privilege « User Permission « SQL / MySQL






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

Check out the privilege for a user

/* oost is the usr name */
SELECT host, db, user, table_name, table_priv, column_priv 
   FROM tables_priv WHERE user='oost';








Related examples in the same category

1.Check the privilege
2.Grant select and update on two column in a table
3.Grant with user name and password
4.Grant select and update to all tables
5.Grant select and update with time limitation
6.List the host, DB, table name and column name for a user
7.Adding Users to Database
8.Read the user table
9.Read host, db, user, table name and table privilege from privilege table
10.Read column privilege