Page MenuHomePhabricator

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


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 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