Mega Code Archive

 

Categories / MySQL / User Permission

 

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