Changeset c73b2b53bb74c7e8135888bc652903c9327f7dbd

Show
Ignore:
Timestamp:
09/25/08 19:24:59 (6 years ago)
Author:
Denish Patel <denish@omniti.com>
git-committer:
Denish Patel <denish@omniti.com> 1222370699 +0000
git-parent:

[15df64bd213a7a14a521d3d2d4418ee9379272aa]

git-author:
Denish Patel <denish@omniti.com> 1222370699 +0000
Message:

granted more privs to stratcon user

Files:

Legend:

Unmodified
Added
Removed
Modified
Copied
Moved
  • sql/reconnoiter_ddl_dump.sql

    r15df64b rc73b2b5  
    23372337 
    23382338 
     2339SET search_path = prism, pg_catalog; 
     2340 
     2341-- 
     2342-- Name: idx_saved_graphs_ts_search_all; Type: INDEX; Schema: prism; Owner: reconnoiter; Tablespace:  
     2343-- 
     2344 
     2345CREATE INDEX idx_saved_graphs_ts_search_all ON saved_graphs USING btree (ts_search_all); 
     2346 
     2347 
     2348SET search_path = stratcon, pg_catalog; 
     2349 
    23392350-- 
    23402351-- Name: idx_metric_name_summary_ts_search_all; Type: INDEX; Schema: stratcon; Owner: reconnoiter; Tablespace:  
     
    25412552GRANT ALL ON TABLE current_metric_text TO reconnoiter; 
    25422553GRANT SELECT ON TABLE current_metric_text TO prism; 
    2543 GRANT SELECT,INSERT,UPDATE ON TABLE current_metric_text TO stratcon; 
     2554GRANT SELECT,INSERT,DELETE,UPDATE ON TABLE current_metric_text TO stratcon; 
    25442555 
    25452556 
     
    25522563GRANT ALL ON TABLE current_node_config TO reconnoiter; 
    25532564GRANT SELECT ON TABLE current_node_config TO prism; 
    2554 GRANT SELECT,INSERT,UPDATE ON TABLE current_node_config TO stratcon; 
     2565GRANT SELECT,INSERT,DELETE,UPDATE ON TABLE current_node_config TO stratcon; 
    25552566 
    25562567 
     
    25632574GRANT ALL ON TABLE current_node_config_changelog TO reconnoiter; 
    25642575GRANT SELECT ON TABLE current_node_config_changelog TO prism; 
    2565 GRANT SELECT,INSERT,UPDATE ON TABLE current_node_config_changelog TO stratcon; 
     2576GRANT SELECT,INSERT,DELETE,UPDATE ON TABLE current_node_config_changelog TO stratcon; 
    25662577 
    25672578 
     
    25732584REVOKE ALL ON TABLE loading_dock_check_s FROM reconnoiter; 
    25742585GRANT ALL ON TABLE loading_dock_check_s TO reconnoiter; 
    2575 GRANT SELECT,INSERT,UPDATE ON TABLE loading_dock_check_s TO stratcon; 
     2586GRANT SELECT,INSERT,DELETE,UPDATE ON TABLE loading_dock_check_s TO stratcon; 
    25762587GRANT SELECT ON TABLE loading_dock_check_s TO prism; 
    25772588 
     
    25842595REVOKE ALL ON TABLE loading_dock_metric_numeric_s FROM reconnoiter; 
    25852596GRANT ALL ON TABLE loading_dock_metric_numeric_s TO reconnoiter; 
    2586 GRANT SELECT,INSERT,UPDATE ON TABLE loading_dock_metric_numeric_s TO stratcon; 
     2597GRANT SELECT,INSERT,DELETE,UPDATE ON TABLE loading_dock_metric_numeric_s TO stratcon; 
    25872598GRANT SELECT ON TABLE loading_dock_metric_numeric_s TO prism; 
    25882599 
     
    26062617REVOKE ALL ON TABLE loading_dock_metric_text_s_change_log FROM reconnoiter; 
    26072618GRANT ALL ON TABLE loading_dock_metric_text_s_change_log TO reconnoiter; 
    2608 GRANT SELECT,INSERT,UPDATE ON TABLE loading_dock_metric_text_s_change_log TO stratcon; 
     2619GRANT SELECT,INSERT,DELETE,UPDATE ON TABLE loading_dock_metric_text_s_change_log TO stratcon; 
    26092620GRANT SELECT ON TABLE loading_dock_metric_text_s_change_log TO prism; 
    26102621 
     
    26172628REVOKE ALL ON TABLE loading_dock_status_s FROM reconnoiter; 
    26182629GRANT ALL ON TABLE loading_dock_status_s TO reconnoiter; 
    2619 GRANT SELECT,INSERT,UPDATE ON TABLE loading_dock_status_s TO stratcon; 
     2630GRANT SELECT,INSERT,DELETE,UPDATE ON TABLE loading_dock_status_s TO stratcon; 
    26202631GRANT SELECT ON TABLE loading_dock_status_s TO prism; 
    26212632 
     
    26502661REVOKE ALL ON TABLE map_uuid_to_sid FROM reconnoiter; 
    26512662GRANT ALL ON TABLE map_uuid_to_sid TO reconnoiter; 
    2652 GRANT SELECT,INSERT,UPDATE ON TABLE map_uuid_to_sid TO stratcon; 
     2663GRANT SELECT,INSERT,DELETE,UPDATE ON TABLE map_uuid_to_sid TO stratcon; 
    26532664GRANT SELECT ON TABLE map_uuid_to_sid TO prism; 
    26542665 
     
    26732684GRANT ALL ON TABLE metric_tags TO reconnoiter; 
    26742685GRANT ALL ON TABLE metric_tags TO prism; 
     2686GRANT SELECT,INSERT,DELETE,UPDATE ON TABLE metric_tags TO stratcon; 
    26752687 
    26762688 
     
    26932705REVOKE ALL ON TABLE rollup_matrix_numeric_12hours FROM reconnoiter; 
    26942706GRANT ALL ON TABLE rollup_matrix_numeric_12hours TO reconnoiter; 
    2695 GRANT SELECT,INSERT,DELETE ON TABLE rollup_matrix_numeric_12hours TO stratcon; 
     2707GRANT SELECT,INSERT,DELETE,UPDATE ON TABLE rollup_matrix_numeric_12hours TO stratcon; 
    26962708GRANT SELECT ON TABLE rollup_matrix_numeric_12hours TO prism; 
    26972709 
     
    27042716REVOKE ALL ON TABLE rollup_matrix_numeric_20m FROM reconnoiter; 
    27052717GRANT ALL ON TABLE rollup_matrix_numeric_20m TO reconnoiter; 
    2706 GRANT SELECT,INSERT,DELETE ON TABLE rollup_matrix_numeric_20m TO stratcon; 
     2718GRANT SELECT,INSERT,DELETE,UPDATE ON TABLE rollup_matrix_numeric_20m TO stratcon; 
    27072719GRANT SELECT ON TABLE rollup_matrix_numeric_20m TO prism; 
    27082720 
     
    27262738REVOKE ALL ON TABLE rollup_matrix_numeric_60m FROM reconnoiter; 
    27272739GRANT ALL ON TABLE rollup_matrix_numeric_60m TO reconnoiter; 
    2728 GRANT SELECT,INSERT,DELETE ON TABLE rollup_matrix_numeric_60m TO stratcon; 
     2740GRANT SELECT,INSERT,DELETE,UPDATE ON TABLE rollup_matrix_numeric_60m TO stratcon; 
    27292741GRANT SELECT ON TABLE rollup_matrix_numeric_60m TO prism; 
    27302742 
     
    27372749REVOKE ALL ON TABLE rollup_matrix_numeric_6hours FROM reconnoiter; 
    27382750GRANT ALL ON TABLE rollup_matrix_numeric_6hours TO reconnoiter; 
    2739 GRANT SELECT,INSERT,DELETE ON TABLE rollup_matrix_numeric_6hours TO stratcon; 
     2751GRANT SELECT,INSERT,DELETE,UPDATE ON TABLE rollup_matrix_numeric_6hours TO stratcon; 
    27402752GRANT SELECT ON TABLE rollup_matrix_numeric_6hours TO prism; 
    27412753