Changeset b4c0bb19ecdfe7283237a73c2e71a43d343e4210
- Timestamp:
- 10/20/09 21:21:11
(9 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
r7b411d3 |
rb4c0bb1 |
|
52 | 52 | -- |
---|
53 | 53 | |
---|
54 | | CREATE TRIGGER update_mns_via_check_currently |
---|
| 54 | CREATE TRIGGER update_metric_name_summary_fulltext |
---|
55 | 55 | AFTER INSERT OR UPDATE ON check_currently |
---|
56 | 56 | FOR EACH ROW |
---|
r2b8f8c2 |
rb4c0bb1 |
|
61 | 61 | |
---|
62 | 62 | REVOKE 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; |
---|
65 | 63 | GRANT ALL ON TABLE check_tag TO prism; |
---|
66 | 64 | GRANT SELECT,INSERT,DELETE,UPDATE ON TABLE check_tag TO stratcon; |
---|
r2b8f8c2 |
rb4c0bb1 |
|
51 | 51 | -- |
---|
52 | 52 | |
---|
53 | | CREATE TRIGGER update_metric_name_summary |
---|
| 53 | CREATE TRIGGER update_metric_name_summary_fulltext |
---|
54 | 54 | BEFORE INSERT OR UPDATE ON metric_name_summary |
---|
55 | 55 | FOR EACH ROW |
---|
… | … | |
62 | 62 | |
---|
63 | 63 | REVOKE 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; |
---|
66 | 64 | GRANT SELECT,INSERT,DELETE,UPDATE ON TABLE metric_name_summary TO stratcon; |
---|
67 | 65 | GRANT SELECT,UPDATE ON TABLE metric_name_summary TO prism; |
---|
r4bd7d84 |
rb4c0bb1 |
|
41 | 41 | -- |
---|
42 | 42 | |
---|
43 | | CREATE TRIGGER update_metric_name_summary |
---|
| 43 | CREATE TRIGGER update_metric_name_summary_fulltext |
---|
44 | 44 | AFTER INSERT OR UPDATE ON metric_tag |
---|
45 | 45 | FOR EACH ROW |
---|
… | … | |
61 | 61 | |
---|
62 | 62 | REVOKE 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; |
---|
65 | 63 | GRANT ALL ON TABLE metric_tag TO prism; |
---|
66 | 64 | GRANT SELECT,INSERT,DELETE,UPDATE ON TABLE metric_tag TO stratcon; |
---|