Bug #70928 Error message erroneously claims that SELECT from P_S table is denied

• Submitted: 16 Nov 2013 13:42
• Modified: 18 Nov 2013 9:33
• Reporter: Peter Laursen (Basic Quality Contributor)
• Status: Verified
• Category: MySQL Server: Security: Privileges
• Severity: S3 (Non-critical)
• Version: 5.6.14, 5.7.2-m12
• OS: Any
• CPU Architecture: Any

[16 Nov 2013 13:42] Peter Laursen

Description:
USE `performance_schema`;

LOCK TABLES `events_statements_history` READ;
-- Error Code: 1142
-- SELECT, LOCK TABLES command denied to user 'root'@'localhost' for table 'events_statements_history'

-- However this works as a charm:
SELECT * FROM `events_statements_history` -- success

.. so SELECT command is *not* denied and error message is wrong.

How to repeat:
See above

Suggested fix:
Clean up error message.

[18 Nov 2013 9:33] MySQL Verification Team

Hello Peter,

Thank you for the bug report.
Verified as described.

Thanks,
Umesh