Details
-
New Feature
-
Status: Open (View Workflow)
-
Major
-
Resolution: Unresolved
-
None
Description
This feature would allow a DBA to optimize queries without having full access to date (even accidentally).
This would be a special privilege that would allow a DBA access to all databases and schemas,
but any select query would return 0 for numerical data and '*' for other data.
EXPLAIN and SHOW commands would not be affected.
-Maybe allow queries that only touches information_schema?
One shortcoming of this solution is that a user with this privilege could deduce some information from the system by using queries with like, >= and <=.
Because of this, all queries the users does should be logged to the general log to ensure that the user is not abusing his privilege.
This feature could be very useful when a DBA is asked to login to a user database and do queries while the customer is watching (a common practice in these cases).
It would ensure that the DBA does not accidentally see any data.
The Implementation of this would be relatively easy by using a special 'Protocol' class that is used by users with this privilege when select queries are used.
In theory a user can give