Page MenuHomePhabricator

Assign "SHOW VIEW" privileges to labs-users on the replica databases
Closed, DuplicatePublic

Description

It's not possible to do EXPLAIN's on the replica databases:

MariaDB [nowiki_p]>  EXPLAIN SELECT page_id FROM page WHERE page_id=1;
ERROR 1345 (HY000): EXPLAIN/SHOW can not be issued; lacking privileges for underlying table

According to https://bugs.mysql.com/bug.php?id=64198 this is due to missing the "SHOW VIEW" privileges. Is this possible to be part of the default privileges?

Event Timeline

Stigmj created this task.Jan 6 2016, 5:02 PM
Stigmj raised the priority of this task from to Needs Triage.
Stigmj updated the task description. (Show Details)
Stigmj added projects: Toolforge, DBA.
Stigmj added a subscriber: Stigmj.
Restricted Application added a project: Cloud-Services. · View Herald TranscriptJan 6 2016, 5:02 PM
Restricted Application added subscribers: StudiesWorld, Aklapper. · View Herald Transcript