Closed
Bug 774314
Opened 14 years ago
Closed 14 years ago
bugzilla needs new field permissions added to it
Categories
(Data & BI Services Team :: DB: MySQL, task)
Tracking
(Not tracked)
RESOLVED
FIXED
People
(Reporter: scabral, Assigned: scabral)
Details
We should run this on production:
GRANT SELECT ON `bugs`.`cf_status_seamonkey214` TO 'metrics'@'10.8.70.20_';
GRANT SELECT (cf_status_seamonkey214) ON `bugs`.`bugs` TO 'metrics'@'10.8.70.20_';
GRANT SELECT ON `bugs`.`cf_status_seamonkey214` TO 'metrics'@'10.8.70.21_';
GRANT SELECT (cf_status_seamonkey214) ON `bugs`.`bugs` TO 'metrics'@'10.8.70.21_';
|
Assignee | |
Updated•14 years ago
|
Assignee: server-ops-database → scabral
|
|
Assignee | |
Comment 1•14 years ago
|
||
Also:
GRANT SELECT ON `bugs`.`cf_tracking_seamonkey214` TO 'metrics'@'10.8.70.20_';
GRANT SELECT (cf_tracking_seamonkey214) ON `bugs`.`bugs` TO 'metrics'@'10.8.70.20_';
GRANT SELECT ON `bugs`.`cf_tracking_seamonkey214` TO 'metrics'@'10.8.70.21_';
GRANT SELECT (cf_tracking_seamonkey214) ON `bugs`.`bugs` TO 'metrics'@'10.8.70.21_';
GRANT SELECT ON `bugs`.`cf_status_thunderbird17` TO 'metrics'@'10.8.70.20_';
GRANT SELECT (cf_status_thunderbird17) ON `bugs`.`bugs` TO 'metrics'@'10.8.70.20_';
GRANT SELECT ON `bugs`.`cf_status_thunderbird17` TO 'metrics'@'10.8.70.21_';
GRANT SELECT (cf_status_thunderbird17) ON `bugs`.`bugs` TO 'metrics'@'10.8.70.21_';
GRANT SELECT ON `bugs`.`cf_tracking_thunderbird17` TO 'metrics'@'10.8.70.20_';
GRANT SELECT (cf_tracking_thunderbird17) ON `bugs`.`bugs` TO 'metrics'@'10.8.70.20_';
GRANT SELECT ON `bugs`.`cf_tracking_thunderbird17` TO 'metrics'@'10.8.70.21_';
GRANT SELECT (cf_tracking_thunderbird17) ON `bugs`.`bugs` TO 'metrics'@'10.8.70.21_';
GRANT SELECT ON `bugs`.`cf_status_firefox17` TO 'metrics'@'10.8.70.20_';
GRANT SELECT (cf_status_firefox17) ON `bugs`.`bugs` TO 'metrics'@'10.8.70.20_';
GRANT SELECT ON `bugs`.`cf_status_firefox17` TO 'metrics'@'10.8.70.21_';
GRANT SELECT (cf_status_firefox17) ON `bugs`.`bugs` TO 'metrics'@'10.8.70.21_';
GRANT SELECT ON `bugs`.`cf_tracking_firefox17` TO 'metrics'@'10.8.70.20_';
GRANT SELECT (cf_tracking_firefox17) ON `bugs`.`bugs` TO 'metrics'@'10.8.70.20_';
GRANT SELECT ON `bugs`.`cf_tracking_firefox17` TO 'metrics'@'10.8.70.21_';
GRANT SELECT (cf_tracking_firefox17) ON `bugs`.`bugs` TO 'metrics'@'10.8.70.21_';
Summary: bugzilla needs seamonkey214 added to it → bugzilla needs new field permissions added to it
|
|
Assignee | |
Comment 2•14 years ago
|
||
Done on production:
mysql> use bugs;
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A
Database changed
mysql> GRANT SELECT ON `bugs`.`cf_status_seamonkey214` TO 'metrics'@'10.8.70.20_';
Query OK, 0 rows affected (0.00 sec)
mysql> GRANT SELECT (cf_status_seamonkey214) ON `bugs`.`bugs` TO 'metrics'@'10.8.70.20_';
Query OK, 0 rows affected (0.00 sec)
mysql> GRANT SELECT ON `bugs`.`cf_status_seamonkey214` TO 'metrics'@'10.8.70.21_';
Query OK, 0 rows affected (0.00 sec)
mysql> GRANT SELECT (cf_status_seamonkey214) ON `bugs`.`bugs` TO 'metrics'@'10.8.70.21_';
Query OK, 0 rows affected (0.00 sec)
mysql> GRANT SELECT ON `bugs`.`cf_tracking_seamonkey214` TO 'metrics'@'10.8.70.20_';
Query OK, 0 rows affected (0.00 sec)
mysql> GRANT SELECT (cf_tracking_seamonkey214) ON `bugs`.`bugs` TO 'metrics'@'10.8.70.20_';
Query OK, 0 rows affected (0.00 sec)
mysql> GRANT SELECT ON `bugs`.`cf_tracking_seamonkey214` TO 'metrics'@'10.8.70.21_';
Query OK, 0 rows affected (0.00 sec)
mysql> GRANT SELECT (cf_tracking_seamonkey214) ON `bugs`.`bugs` TO 'metrics'@'10.8.70.21_';
Query OK, 0 rows affected (0.00 sec)
mysql> GRANT SELECT ON `bugs`.`cf_status_thunderbird17` TO 'metrics'@'10.8.70.20_';
Query OK, 0 rows affected (0.00 sec)
mysql> GRANT SELECT (cf_status_thunderbird17) ON `bugs`.`bugs` TO 'metrics'@'10.8.70.20_';
Query OK, 0 rows affected (0.00 sec)
mysql> GRANT SELECT ON `bugs`.`cf_status_thunderbird17` TO 'metrics'@'10.8.70.21_';
Query OK, 0 rows affected (0.00 sec)
mysql> GRANT SELECT (cf_status_thunderbird17) ON `bugs`.`bugs` TO 'metrics'@'10.8.70.21_';
Query OK, 0 rows affected (0.00 sec)
mysql> GRANT SELECT ON `bugs`.`cf_tracking_thunderbird17` TO 'metrics'@'10.8.70.20_';
Query OK, 0 rows affected (0.00 sec)
mysql> GRANT SELECT (cf_tracking_thunderbird17) ON `bugs`.`bugs` TO 'metrics'@'10.8.70.20_';
Query OK, 0 rows affected (0.00 sec)
mysql> GRANT SELECT ON `bugs`.`cf_tracking_thunderbird17` TO 'metrics'@'10.8.70.21_';
Query OK, 0 rows affected (0.00 sec)
mysql> GRANT SELECT (cf_tracking_thunderbird17) ON `bugs`.`bugs` TO 'metrics'@'10.8.70.21_';
Query OK, 0 rows affected (0.00 sec)
mysql> GRANT SELECT ON `bugs`.`cf_status_firefox17` TO 'metrics'@'10.8.70.20_';
Query OK, 0 rows affected (0.01 sec)
mysql> GRANT SELECT (cf_status_firefox17) ON `bugs`.`bugs` TO 'metrics'@'10.8.70.20_';
Query OK, 0 rows affected (0.00 sec)
mysql> GRANT SELECT ON `bugs`.`cf_status_firefox17` TO 'metrics'@'10.8.70.21_';
Query OK, 0 rows affected (0.00 sec)
mysql> GRANT SELECT (cf_status_firefox17) ON `bugs`.`bugs` TO 'metrics'@'10.8.70.21_';
Query OK, 0 rows affected (0.00 sec)
mysql> GRANT SELECT ON `bugs`.`cf_tracking_firefox17` TO 'metrics'@'10.8.70.20_';
Query OK, 0 rows affected (0.01 sec)
mysql> GRANT SELECT (cf_tracking_firefox17) ON `bugs`.`bugs` TO 'metrics'@'10.8.70.20_';
Query OK, 0 rows affected (0.00 sec)
mysql> GRANT SELECT ON `bugs`.`cf_tracking_firefox17` TO 'metrics'@'10.8.70.21_';
Query OK, 0 rows affected (0.00 sec)
mysql> GRANT SELECT (cf_tracking_firefox17) ON `bugs`.`bugs` TO 'metrics'@'10.8.70.21_';
Query OK, 0 rows affected (0.00 sec)
Status: NEW → RESOLVED
Closed: 14 years ago
Resolution: --- → FIXED
|
||
Updated•11 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
•