User Permission MySQL

  1. Home
  2. MySQL
  3. User Permission
  4. Read host, db, user, table name and table privilege from privilege table
SELECT host, db, user, table_name, table_priv, column_priv 
   FROM tables_priv WHERE user='myuserName';