Show
Ignore:
Timestamp:
10/20/09 21:21:11 (4 years ago)
Author:
Robert Treat <robert@omniti.com>
git-committer:
Robert Treat <robert@omniti.com> 1256073671 +0000
git-parent:

[7b411d3b64a0cefe7a6ad99c78edfe85c96f3835]

git-author:
Robert Treat <robert@omniti.com> 1256073671 +0000
Message:

trigger updates for metric name summary management, also some perms cleaning

Files:

Legend:

Unmodified
Added
Removed
Modified
Copied
Moved
  • sql/tables/noit.check_currently.sql

    r7b411d3 rb4c0bb1  
    5252-- 
    5353 
    54 CREATE TRIGGER update_mns_via_check_currently 
     54CREATE TRIGGER update_metric_name_summary_fulltext  
    5555    AFTER INSERT OR UPDATE ON check_currently 
    5656    FOR EACH ROW 
  • sql/tables/noit.check_tag.sql

    r2b8f8c2 rb4c0bb1  
    6161 
    6262REVOKE ALL ON TABLE check_tag FROM PUBLIC; 
    63 REVOKE ALL ON TABLE check_tag FROM reconnoiter; 
    64 GRANT ALL ON TABLE check_tag TO reconnoiter; 
    6563GRANT ALL ON TABLE check_tag TO prism; 
    6664GRANT SELECT,INSERT,DELETE,UPDATE ON TABLE check_tag TO stratcon; 
  • sql/tables/noit.metric_name_summary.sql

    r2b8f8c2 rb4c0bb1  
    5151-- 
    5252 
    53 CREATE TRIGGER update_metric_name_summary 
     53CREATE TRIGGER update_metric_name_summary_fulltext  
    5454    BEFORE INSERT OR UPDATE ON metric_name_summary 
    5555    FOR EACH ROW 
     
    6262 
    6363REVOKE ALL ON TABLE metric_name_summary FROM PUBLIC; 
    64 REVOKE ALL ON TABLE metric_name_summary FROM reconnoiter; 
    65 GRANT ALL ON TABLE metric_name_summary TO reconnoiter; 
    6664GRANT SELECT,INSERT,DELETE,UPDATE ON TABLE metric_name_summary TO stratcon; 
    6765GRANT SELECT,UPDATE ON TABLE metric_name_summary TO prism; 
  • sql/tables/noit.metric_tag.sql

    r4bd7d84 rb4c0bb1  
    4141-- 
    4242 
    43 CREATE TRIGGER update_metric_name_summary 
     43CREATE TRIGGER update_metric_name_summary_fulltext  
    4444    AFTER INSERT OR UPDATE ON metric_tag 
    4545    FOR EACH ROW 
     
    6161 
    6262REVOKE ALL ON TABLE metric_tag FROM PUBLIC; 
    63 REVOKE ALL ON TABLE metric_tag FROM reconnoiter; 
    64 GRANT ALL ON TABLE metric_tag TO reconnoiter; 
    6563GRANT ALL ON TABLE metric_tag TO prism; 
    6664GRANT SELECT,INSERT,DELETE,UPDATE ON TABLE metric_tag TO stratcon;