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

Assigned To

None

Authored By

	Stigmj
	Jan 6 2016, 5:02 PM

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

Restricted Application added a project: Cloud-Services. · View Herald TranscriptJan 6 2016, 5:02 PM

Restricted Application added subscribers: StudiesWorld, Aklapper. · View Herald Transcript

valhallasw closed this task as a duplicate of T50875: Unable to explain queries on replicated databases.Jan 6 2016, 5:07 PM

Assign "SHOW VIEW" privileges to labs-users on the replica databasesClosed, DuplicatePublicActions

Description

Event Timeline

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