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

Status: VERIFIED FIXED

(Data & BI Services Team :: DB: MySQL, task)

Description

[Mark Reid [:mreid]]

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.

Comment 1

[:glob ✱]

this table doesn't contain any confidential information and it's ok for metrics to have access to it.

Comment 2

[Sheeri Cabral [:sheeri]]

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)

Comment 3

[Mark Reid [:mreid]]

Verified that I now have access.  Thanks!