Closed
Bug 764387
Opened 12 years ago
Closed 12 years ago
Please add select permission for "bug_see_also" table to "metrics" database user
Categories
(Data & BI Services Team :: DB: MySQL, task)
Data & BI Services Team
DB: MySQL
Tracking
(Not tracked)
VERIFIED
FIXED
People
(Reporter: mreid, Assigned: scabral)
Details
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•12 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•12 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
Closed: 12 years ago
Resolution: --- → FIXED
Reporter | ||
Comment 3•12 years ago
|
||
Verified that I now have access. Thanks!
Status: RESOLVED → VERIFIED
Updated•10 years ago
|
Product: mozilla.org → Data & BI Services Team
You need to log in
before you can comment on or make changes to this bug.
Description
•