Mega Code Archive

 

Categories / MySQL / User Permission

 

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