When I am working in the production database, I typically use a read-only userid, so that I don’t accidentally update the wrong database, thinking I’m in development instead.
Using this ID, when I issue a query that uses a view, I get this error message:
Error Number: 1345
EXPLAIN/SHOW can not be issued; lacking privileges for underlying table
Which shows up in a pop-up dialog. When I close the dialog, the results of my query are available. This happens every time and is quite a nuisance.
Can you please show that particular error somewhere else (e.g. the Messages Pane)?