Last modified: 2014-07-05 13:30:42 UTC
normal users have no read access to mysql.db, mysql.table_priv and mysql.columns_priv "show grants" shows all rights the current user has, but there is no possibility to show a list of privileges given to foreign users for own databases. It would be useful to have a procedure with "SQL SECURITY DEFINER" created by a user having read access to these databases which can be called by normal users. It should list all privileges given to prefixed user databases or tables/columns of these (db like 's1234_%').