Bug #109216 ERROR 1345 (HY000): EXPLAIN/SHOW can not be issued; lacking privileges for under

• Submitted: 28 Nov 2022 6:02
• Modified: 28 Nov 2022 13:03
• Reporter: Sheenam Setia
• Status: Can't repeat
• Category: MySQL Server
• Severity: S2 (Serious)
• Version: 5.7.39
• OS: Any
• CPU Architecture: Any

[28 Nov 2022 6:02] Sheenam Setia

Description:
Hi Team, Good day. We've got a weird bug that we've been unable to pin down for one of our client. They create specific database users that only have read access to specific VIEWS on the read replica (not the underlying tables) - starting a few weeks back users are facing issue in the BI tools they use to connect to the read replicas and create reports started getting this error intermittently -'ERROR 1345 (HY000): EXPLAIN/SHOW can not be issued; lacking privileges for underlying table' re-running the query would  allow the query to run on every 2nd or 3rd attempt. The issue is exactly the same when the queries are run directly on the database. The read replica mysql version is 5.7.38/39. Environment: gcp cloud mysql instance.
Does anyone have any idea on it? TIA.

How to repeat:
Running 'Select * from 'table_name''; where the user has access. The issue is intermittent.

[28 Nov 2022 13:03] MySQL Verification Team

Hi Mr. Setia,

Thank you for your bug report. However ......

Not enough information was provided for us to be able to handle this bug. Please re-read the instructions at http://bugs.mysql.com/how-to-report.php 

If you can provide more information, feel free to add it to this bug and if the test case is sufficient and reproducible , we shall change the status back to 'Open'.  

Thank you for your interest in MySQL.