Page MenuHomePhabricator

mariadb: grant user 'phstats' additional select on phabricator_search db
Closed, ResolvedPublic

Description

(A quite late followup to T238425)

Vague idea to run read-only SQL queries to potentially clean up Phab project page sidebar menu items (like querying for duplicated "Open Tasks" items which we do have due to manual creation before that item became an upstream default built-in one), also cf https://secure.phabricator.com/T7410 or T105865 here when it comes to workboard menu items when workboards just aren't used.

Project page menu items are stored in the phabricator_search.search_profilepanelconfiguration table. (Yeah, not very obvious.)

Event Timeline

Aklapper triaged this task as Low priority.

Change 862895 had a related patch set uploaded (by Aklapper; author: Aklapper):

[operations/puppet@production] mariadb: grant user 'phstats' additional select on phabricator_search db

https://gerrit.wikimedia.org/r/862895

Change 862895 merged by Marostegui:

[operations/puppet@production] mariadb: grant user 'phstats' additional select on phabricator_search db

https://gerrit.wikimedia.org/r/862895

Marostegui claimed this task.
Marostegui subscribed.

Merged and applied the grants. Please test it and reopen if it is not working!
Thanks!