User Permission MySQL

  1. Home
  2. MySQL
  3. User Permission
  4. List the host, DB, table name and column name for a user
/* oost is the usr name */
SELECT host, db, user, table_name, column_name, column_priv 
   FROM columns_priv WHERE user='oost';