Changeset b4c0bb19ecdfe7283237a73c2e71a43d343e4210
- Timestamp:
- 10/20/09 21:21:11
(5 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; |
|---|
