730391 - adding custom fields to bmo - cf_blocking_fennec10

Status: RESOLVED FIXED

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

Description

[Sheeri Cabral [:sheeri]]

The custom field 'cf_blocking_fennec10' has been added to the BMO database.

Please run the following on tm-bugs01-master01:
  GRANT SELECT ON `bugs`.`cf_blocking_fennec10` TO 'metrics'@'10.2.70.20_';
  GRANT SELECT (cf_blocking_fennec10) ON `bugs`.`bugs` TO 'metrics'@'10.2.70.20_';

Comment 1

[Sheeri Cabral [:sheeri]]

[scabral@tm-bugs01-master01 ~]$ mysql
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 466190
Server version: 5.0.77-log Source distribution

Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

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

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