https://bugzilla.wikimedia.org/show_bug.cgi?id=67552
Bug ID: 67552
Summary: create procedure to show all granted permission to
foreign user for own user databases
Product: Wikimedia Labs
Version: unspecified
Hardware: All
OS: All
Status: NEW
Severity: normal
Priority: Unprioritized
Component: tools
Assignee: [email protected]
Reporter: [email protected]
CC: [email protected], [email protected]
Web browser: ---
Mobile Platform: ---
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_%').
--
You are receiving this mail because:
You are on the CC list for the bug.
_______________________________________________
Wikibugs-l mailing list
[email protected]
https://lists.wikimedia.org/mailman/listinfo/wikibugs-l
