Please add select permission for "bug_see_also" table to "metrics" database user

VERIFIED FIXED

Status

Data & BI Services Team
DB: MySQL
VERIFIED FIXED
6 years ago
3 years ago

People

(Reporter: mreid, Assigned: sheeri)

Tracking

Details

(Reporter)

Description

6 years ago
The "metrics" user in the "bugs" database on tp-bugs01-ro-zeus.phx.mozilla.com does not currently have select access to the "bug_see_also" table.  We would like to use that information when importing bug data into ElasticSearch for the Bugzilla Anthropology project.
(Assignee)

Updated

6 years ago
Assignee: server-ops-database → scabral
this table doesn't contain any confidential information and it's ok for metrics to have access to it.
(Assignee)

Comment 2

6 years ago
Done, let me know if it doesn't work:


mysql> select user,host from mysql.user where user='metrics';
+---------+-------------+
| user    | host        |
+---------+-------------+
| metrics | 10.2.72.20_ | 
| metrics | 10.2.72.28  | 
| metrics | 10.2.72.34  | 
| metrics | 10.8.70.20_ | 
| metrics | 10.8.70.21_ | 
+---------+-------------+
5 rows in set (0.00 sec)

mysql> grant SELECT on bugs.bug_see_also to metrics@10.2.72.20_;
Query OK, 0 rows affected (0.00 sec)

mysql> grant SELECT on bugs.bug_see_also to metrics@10.2.72.28;
Query OK, 0 rows affected (0.01 sec)

mysql> grant SELECT on bugs.bug_see_also to metrics@10.2.72.34;
Query OK, 0 rows affected (0.01 sec)

mysql> grant SELECT on bugs.bug_see_also to metrics@10.8.70.20_;
Query OK, 0 rows affected (0.00 sec)

mysql> grant SELECT on bugs.bug_see_also to metrics@10.8.70.21_;
Query OK, 0 rows affected (0.01 sec)
Status: NEW → RESOLVED
Last Resolved: 6 years ago
Resolution: --- → FIXED
(Reporter)

Comment 3

6 years ago
Verified that I now have access.  Thanks!
Status: RESOLVED → VERIFIED
(Reporter)

Updated

6 years ago
Blocks: 765212
(Reporter)

Updated

6 years ago
No longer blocks: 765212
Product: mozilla.org → Data & BI Services Team
You need to log in before you can comment on or make changes to this bug.