Read host, db, user, table name and table privilege from privilege table : SQL Privilege « User Permission « SQL / MySQL






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

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';








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.Check out the privilege for a user
7.List the host, DB, table name and column name for a user
8.Adding Users to Database
9.Read the user table
10.Read column privilege