New statements to run on bugzilla db servers

RESOLVED FIXED

Status

Data & BI Services Team
DB: MySQL
RESOLVED FIXED
6 years ago
4 years ago

People

(Reporter: sheeri, Unassigned)

Tracking

Details

(Reporter)

Description

6 years ago
GRANT SELECT ON `bugs`.`cf_status_seamonkey212` TO 'metrics'@'10.2.70.20_';
  GRANT SELECT (cf_status_seamonkey212) ON `bugs`.`bugs` TO 'metrics'@'10.2.70.20_';
  GRANT SELECT ON `bugs`.`cf_status_seamonkey212` TO 'metrics'@'10.2.70.20_';
  GRANT SELECT (cf_status_seamonkey212) ON `bugs`.`bugs` TO 'metrics'@'10.2.70.20_';
  GRANT SELECT ON `bugs`.`cf_status_thunderbird15` TO 'metrics'@'10.2.70.20_';
  GRANT SELECT (cf_status_thunderbird15) ON `bugs`.`bugs` TO 'metrics'@'10.2.70.20_';
  GRANT SELECT ON `bugs`.`cf_tracking_thunderbird15` TO 'metrics'@'10.2.70.20_';
  GRANT SELECT (cf_tracking_thunderbird15) ON `bugs`.`bugs` TO 'metrics'@'10.2.70.20_';
  GRANT SELECT ON `bugs`.`cf_status_firefox15` TO 'metrics'@'10.2.70.20_';
  GRANT SELECT (cf_status_firefox15) ON `bugs`.`bugs` TO 'metrics'@'10.2.70.20_';
  GRANT SELECT ON `bugs`.`cf_tracking_firefox15` TO 'metrics'@'10.2.70.20_';
  GRANT SELECT (cf_tracking_firefox15) ON `bugs`.`bugs` TO 'metrics'@'10.2.70.20_';
(Reporter)

Comment 1

6 years ago
Done! 

mysql> show variables like 'hostname';
+---------------+------------------------------------+
| Variable_name | Value                              |
+---------------+------------------------------------+
| hostname      | tp-bugs01-master01.phx.mozilla.com | 
+---------------+------------------------------------+
1 row in set (0.00 sec)

mysql>   GRANT SELECT ON `bugs`.`cf_status_seamonkey212` TO 'metrics'@'10.2.70.20_';
Query OK, 0 rows affected (0.00 sec)

mysql>   GRANT SELECT (cf_status_seamonkey212) ON `bugs`.`bugs` TO 'metrics'@'10.2.70.20_';
Query OK, 0 rows affected (0.00 sec)

mysql>   GRANT SELECT ON `bugs`.`cf_status_seamonkey212` TO 'metrics'@'10.2.70.20_';
Query OK, 0 rows affected (0.00 sec)

mysql>   GRANT SELECT (cf_status_seamonkey212) ON `bugs`.`bugs` TO 'metrics'@'10.2.70.20_';
Query OK, 0 rows affected (0.00 sec)

mysql>   GRANT SELECT ON `bugs`.`cf_status_thunderbird15` TO 'metrics'@'10.2.70.20_';
Query OK, 0 rows affected (0.00 sec)

mysql>   GRANT SELECT (cf_status_thunderbird15) ON `bugs`.`bugs` TO 'metrics'@'10.2.70.20_';
Query OK, 0 rows affected (0.00 sec)

mysql>   GRANT SELECT ON `bugs`.`cf_tracking_thunderbird15` TO 'metrics'@'10.2.70.20_';
Query OK, 0 rows affected (0.00 sec)

mysql>   GRANT SELECT (cf_tracking_thunderbird15) ON `bugs`.`bugs` TO 'metrics'@'10.2.70.20_';
Query OK, 0 rows affected (0.00 sec)

mysql>   GRANT SELECT ON `bugs`.`cf_status_firefox15` TO 'metrics'@'10.2.70.20_';
Query OK, 0 rows affected (0.00 sec)

mysql>   GRANT SELECT (cf_status_firefox15) ON `bugs`.`bugs` TO 'metrics'@'10.2.70.20_';
Query OK, 0 rows affected (0.00 sec)

mysql>   GRANT SELECT ON `bugs`.`cf_tracking_firefox15` TO 'metrics'@'10.2.70.20_';
Query OK, 0 rows affected (0.00 sec)

mysql>   GRANT SELECT (cf_tracking_firefox15) ON `bugs`.`bugs` TO 'metrics'@'10.2.70.20_';
Query OK, 0 rows affected (0.00 sec)
Status: NEW → RESOLVED
Last Resolved: 6 years ago
Resolution: --- → FIXED
Product: mozilla.org → Data & BI Services Team
You need to log in before you can comment on or make changes to this bug.