Changeset 70d8a8f096162b8f5ef06f5668066b9e7e942814

Show
Ignore:
Timestamp:
09/22/08 17:57:16 (6 years ago)
Author:
Denish Patel <denish@omniti.com>
git-committer:
Denish Patel <denish@omniti.com> 1222106236 +0000
git-parent:

[362040a384a15e91c42cc65cd4a30d2dbc5600c7]

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

pg ddl update

Files:

Legend:

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

    r8c44e3b r70d8a8f  
    1010 
    1111-- 
    12 -- Name: stratcon; Type: SCHEMA; Schema: -; Owner: - 
     12-- Name: stratcon; Type: SCHEMA; Schema: -; Owner: omniti 
    1313-- 
    1414 
     
    1616 
    1717 
     18ALTER SCHEMA stratcon OWNER TO omniti; 
     19 
    1820SET search_path = stratcon, pg_catalog; 
    1921 
     
    2325 
    2426-- 
    25 -- Name: current_metric_text; Type: TABLE; Schema: stratcon; Owner: -; Tablespace:  
     27-- Name: current_metric_text; Type: TABLE; Schema: stratcon; Owner: reconnoiter; Tablespace:  
    2628-- 
    2729 
     
    3436 
    3537 
    36 -- 
    37 -- Name: current_node_config; Type: TABLE; Schema: stratcon; Owner: -; Tablespace:  
     38ALTER TABLE stratcon.current_metric_text OWNER TO reconnoiter; 
     39 
     40-- 
     41-- Name: current_node_config; Type: TABLE; Schema: stratcon; Owner: reconnoiter; Tablespace:  
    3842-- 
    3943 
     
    4650 
    4751 
    48 -- 
    49 -- Name: current_node_config_changelog; Type: TABLE; Schema: stratcon; Owner: -; Tablespace:  
     52ALTER TABLE stratcon.current_node_config OWNER TO reconnoiter; 
     53 
     54-- 
     55-- Name: current_node_config_changelog; Type: TABLE; Schema: stratcon; Owner: reconnoiter; Tablespace:  
    5056-- 
    5157 
     
    5864 
    5965 
    60 -- 
    61 -- Name: loading_dock_check_s; Type: TABLE; Schema: stratcon; Owner: -; Tablespace:  
     66ALTER TABLE stratcon.current_node_config_changelog OWNER TO reconnoiter; 
     67 
     68-- 
     69-- Name: loading_dock_check_s; Type: TABLE; Schema: stratcon; Owner: reconnoiter; Tablespace:  
    6270-- 
    6371 
     
    7381 
    7482 
    75 -- 
    76 -- Name: loading_dock_metric_numeric_s; Type: TABLE; Schema: stratcon; Owner: -; Tablespace:  
     83ALTER TABLE stratcon.loading_dock_check_s OWNER TO reconnoiter; 
     84 
     85-- 
     86-- Name: loading_dock_metric_numeric_s; Type: TABLE; Schema: stratcon; Owner: reconnoiter; Tablespace:  
    7787-- 
    7888 
     
    8595 
    8696 
    87 -- 
    88 -- Name: loading_dock_metric_text_s; Type: TABLE; Schema: stratcon; Owner: -; Tablespace:  
     97ALTER TABLE stratcon.loading_dock_metric_numeric_s OWNER TO reconnoiter; 
     98 
     99-- 
     100-- Name: loading_dock_metric_text_s; Type: TABLE; Schema: stratcon; Owner: reconnoiter; Tablespace:  
    89101-- 
    90102 
     
    97109 
    98110 
    99 -- 
    100 -- Name: loading_dock_metric_text_s_change_log; Type: TABLE; Schema: stratcon; Owner: -; Tablespace:  
     111ALTER TABLE stratcon.loading_dock_metric_text_s OWNER TO reconnoiter; 
     112 
     113-- 
     114-- Name: loading_dock_metric_text_s_change_log; Type: TABLE; Schema: stratcon; Owner: reconnoiter; Tablespace:  
    101115-- 
    102116 
     
    109123 
    110124 
    111 -- 
    112 -- Name: loading_dock_status_s; Type: TABLE; Schema: stratcon; Owner: -; Tablespace:  
     125ALTER TABLE stratcon.loading_dock_metric_text_s_change_log OWNER TO reconnoiter; 
     126 
     127-- 
     128-- Name: loading_dock_status_s; Type: TABLE; Schema: stratcon; Owner: reconnoiter; Tablespace:  
    113129-- 
    114130 
     
    123139 
    124140 
    125 -- 
    126 -- Name: loading_dock_status_s_change_log; Type: TABLE; Schema: stratcon; Owner: -; Tablespace:  
     141ALTER TABLE stratcon.loading_dock_status_s OWNER TO reconnoiter; 
     142 
     143-- 
     144-- Name: loading_dock_status_s_change_log; Type: TABLE; Schema: stratcon; Owner: reconnoiter; Tablespace:  
    127145-- 
    128146 
     
    137155 
    138156 
    139 -- 
    140 -- Name: log_whence_s; Type: TABLE; Schema: stratcon; Owner: -; Tablespace:  
     157ALTER TABLE stratcon.loading_dock_status_s_change_log OWNER TO reconnoiter; 
     158 
     159-- 
     160-- Name: log_whence_s; Type: TABLE; Schema: stratcon; Owner: reconnoiter; Tablespace:  
    141161-- 
    142162 
     
    147167 
    148168 
    149 -- 
    150 -- Name: map_uuid_to_sid; Type: TABLE; Schema: stratcon; Owner: -; Tablespace:  
     169ALTER TABLE stratcon.log_whence_s OWNER TO reconnoiter; 
     170 
     171-- 
     172-- Name: map_uuid_to_sid; Type: TABLE; Schema: stratcon; Owner: reconnoiter; Tablespace:  
    151173-- 
    152174 
     
    157179 
    158180 
    159 -- 
    160 -- Name: metric_name_summary; Type: TABLE; Schema: stratcon; Owner: -; Tablespace:  
     181ALTER TABLE stratcon.map_uuid_to_sid OWNER TO reconnoiter; 
     182 
     183-- 
     184-- Name: metric_name_summary; Type: TABLE; Schema: stratcon; Owner: reconnoiter; Tablespace:  
    161185-- 
    162186 
     
    169193 
    170194 
    171 -- 
    172 -- Name: mv_loading_dock_check_s; Type: TABLE; Schema: stratcon; Owner: -; Tablespace:  
     195ALTER TABLE stratcon.metric_name_summary OWNER TO reconnoiter; 
     196 
     197-- 
     198-- Name: mv_loading_dock_check_s; Type: TABLE; Schema: stratcon; Owner: reconnoiter; Tablespace:  
    173199-- 
    174200 
     
    184210 
    185211 
    186 -- 
    187 -- Name: rollup_matrix_numeric_12hours; Type: TABLE; Schema: stratcon; Owner: -; Tablespace:  
     212ALTER TABLE stratcon.mv_loading_dock_check_s OWNER TO reconnoiter; 
     213 
     214-- 
     215-- Name: rollup_matrix_numeric_12hours; Type: TABLE; Schema: stratcon; Owner: reconnoiter; Tablespace:  
    188216-- 
    189217 
     
    197225 
    198226 
    199 -- 
    200 -- Name: rollup_matrix_numeric_20m; Type: TABLE; Schema: stratcon; Owner: -; Tablespace:  
     227ALTER TABLE stratcon.rollup_matrix_numeric_12hours OWNER TO reconnoiter; 
     228 
     229-- 
     230-- Name: rollup_matrix_numeric_20m; Type: TABLE; Schema: stratcon; Owner: reconnoiter; Tablespace:  
    201231-- 
    202232 
     
    210240 
    211241 
    212 -- 
    213 -- Name: rollup_matrix_numeric_5m; Type: TABLE; Schema: stratcon; Owner: -; Tablespace:  
     242ALTER TABLE stratcon.rollup_matrix_numeric_20m OWNER TO reconnoiter; 
     243 
     244-- 
     245-- Name: rollup_matrix_numeric_5m; Type: TABLE; Schema: stratcon; Owner: reconnoiter; Tablespace:  
    214246-- 
    215247 
     
    223255 
    224256 
    225 -- 
    226 -- Name: rollup_matrix_numeric_60m; Type: TABLE; Schema: stratcon; Owner: -; Tablespace:  
     257ALTER TABLE stratcon.rollup_matrix_numeric_5m OWNER TO reconnoiter; 
     258 
     259-- 
     260-- Name: rollup_matrix_numeric_60m; Type: TABLE; Schema: stratcon; Owner: reconnoiter; Tablespace:  
    227261-- 
    228262 
     
    236270 
    237271 
    238 -- 
    239 -- Name: rollup_matrix_numeric_6hours; Type: TABLE; Schema: stratcon; Owner: -; Tablespace:  
     272ALTER TABLE stratcon.rollup_matrix_numeric_60m OWNER TO reconnoiter; 
     273 
     274-- 
     275-- Name: rollup_matrix_numeric_6hours; Type: TABLE; Schema: stratcon; Owner: reconnoiter; Tablespace:  
    240276-- 
    241277 
     
    249285 
    250286 
    251 -- 
    252 -- Name: rollup_runner; Type: TABLE; Schema: stratcon; Owner: -; Tablespace:  
     287ALTER TABLE stratcon.rollup_matrix_numeric_6hours OWNER TO reconnoiter; 
     288 
     289-- 
     290-- Name: rollup_runner; Type: TABLE; Schema: stratcon; Owner: reconnoiter; Tablespace:  
    253291-- 
    254292 
     
    259297 
    260298 
    261 -- 
    262 -- Name: choose_window(timestamp without time zone, timestamp without time zone, integer); Type: FUNCTION; Schema: stratcon; Owner: - 
     299ALTER TABLE stratcon.rollup_runner OWNER TO reconnoiter; 
     300 
     301-- 
     302-- Name: choose_window(timestamp without time zone, timestamp without time zone, integer); Type: FUNCTION; Schema: stratcon; Owner: reconnoiter 
    263303-- 
    264304 
     
    309349 
    310350 
    311 -- 
    312 -- Name: choose_window(timestamp with time zone, timestamp with time zone, integer); Type: FUNCTION; Schema: stratcon; Owner: - 
     351ALTER FUNCTION stratcon.choose_window(in_start_time timestamp without time zone, in_end_time timestamp without time zone, in_hopeful_nperiods integer, OUT tablename text, OUT period interval, OUT nperiods integer) OWNER TO reconnoiter; 
     352 
     353-- 
     354-- Name: choose_window(timestamp with time zone, timestamp with time zone, integer); Type: FUNCTION; Schema: stratcon; Owner: reconnoiter 
    313355-- 
    314356 
     
    359401 
    360402 
    361 -- 
    362 -- Name: date_hour(timestamp with time zone); Type: FUNCTION; Schema: stratcon; Owner: - 
     403ALTER FUNCTION stratcon.choose_window(in_start_time timestamp with time zone, in_end_time timestamp with time zone, in_hopeful_nperiods integer, OUT tablename text, OUT period interval, OUT nperiods integer) OWNER TO reconnoiter; 
     404 
     405-- 
     406-- Name: date_hour(timestamp with time zone); Type: FUNCTION; Schema: stratcon; Owner: reconnoiter 
    363407-- 
    364408 
     
    370414 
    371415 
    372 -- 
    373 -- Name: fetch_dataset(uuid, text, timestamp with time zone, timestamp with time zone, integer, boolean); Type: FUNCTION; Schema: stratcon; Owner: - 
     416ALTER FUNCTION stratcon.date_hour(timestamp with time zone) OWNER TO reconnoiter; 
     417 
     418-- 
     419-- Name: fetch_dataset(uuid, text, timestamp with time zone, timestamp with time zone, integer, boolean); Type: FUNCTION; Schema: stratcon; Owner: reconnoiter 
    374420-- 
    375421 
     
    396442 
    397443 
    398 -- 
    399 -- Name: fetch_dataset(integer, text, timestamp with time zone, timestamp with time zone, integer, boolean); Type: FUNCTION; Schema: stratcon; Owner: - 
     444ALTER FUNCTION stratcon.fetch_dataset(in_uuid uuid, in_name text, in_start_time timestamp with time zone, in_end_time timestamp with time zone, in_hopeful_nperiods integer, derive boolean) OWNER TO reconnoiter; 
     445 
     446-- 
     447-- Name: fetch_dataset(integer, text, timestamp with time zone, timestamp with time zone, integer, boolean); Type: FUNCTION; Schema: stratcon; Owner: reconnoiter 
    400448-- 
    401449 
     
    477525 
    478526 
    479 -- 
    480 -- Name: fetch_varset(uuid, text, timestamp with time zone, timestamp with time zone, integer); Type: FUNCTION; Schema: stratcon; Owner: - 
     527ALTER FUNCTION stratcon.fetch_dataset(in_sid integer, in_name text, in_start_time timestamp with time zone, in_end_time timestamp with time zone, in_hopeful_nperiods integer, derive boolean) OWNER TO reconnoiter; 
     528 
     529-- 
     530-- Name: fetch_varset(uuid, text, timestamp with time zone, timestamp with time zone, integer); Type: FUNCTION; Schema: stratcon; Owner: reconnoiter 
    481531-- 
    482532 
     
    498548 
    499549 
    500 -- 
    501 -- Name: fetch_varset(integer, text, timestamp with time zone, timestamp with time zone, integer); Type: FUNCTION; Schema: stratcon; Owner: - 
     550ALTER FUNCTION stratcon.fetch_varset(in_check uuid, in_name text, in_start_time timestamp with time zone, in_end_time timestamp with time zone, in_hopeful_nperiods integer) OWNER TO reconnoiter; 
     551 
     552-- 
     553-- Name: fetch_varset(integer, text, timestamp with time zone, timestamp with time zone, integer); Type: FUNCTION; Schema: stratcon; Owner: reconnoiter 
    502554-- 
    503555 
     
    586638 
    587639 
    588 -- 
    589 -- Name: generate_sid_from_id(uuid); Type: FUNCTION; Schema: stratcon; Owner: - 
     640ALTER FUNCTION stratcon.fetch_varset(in_sid integer, in_name text, in_start_time timestamp with time zone, in_end_time timestamp with time zone, in_hopeful_nperiods integer) OWNER TO reconnoiter; 
     641 
     642-- 
     643-- Name: generate_sid_from_id(uuid); Type: FUNCTION; Schema: stratcon; Owner: reconnoiter 
    590644-- 
    591645 
     
    618672 
    619673 
    620 -- 
    621 -- Name: loading_dock_metric_numeric_s_whence_log(); Type: FUNCTION; Schema: stratcon; Owner: - 
     674ALTER FUNCTION stratcon.generate_sid_from_id(v_in_id uuid) OWNER TO reconnoiter; 
     675 
     676-- 
     677-- Name: loading_dock_metric_numeric_s_whence_log(); Type: FUNCTION; Schema: stratcon; Owner: reconnoiter 
    622678-- 
    623679 
     
    659715 
    660716 
    661 -- 
    662 -- Name: loading_dock_metric_text_s_change_log(); Type: FUNCTION; Schema: stratcon; Owner: - 
     717ALTER FUNCTION stratcon.loading_dock_metric_numeric_s_whence_log() OWNER TO reconnoiter; 
     718 
     719-- 
     720-- Name: loading_dock_metric_text_s_change_log(); Type: FUNCTION; Schema: stratcon; Owner: reconnoiter 
    663721-- 
    664722 
     
    713771 
    714772 
    715 -- 
    716 -- Name: loading_dock_status_s_change_log(); Type: FUNCTION; Schema: stratcon; Owner: - 
     773ALTER FUNCTION stratcon.loading_dock_metric_text_s_change_log() OWNER TO reconnoiter; 
     774 
     775-- 
     776-- Name: loading_dock_status_s_change_log(); Type: FUNCTION; Schema: stratcon; Owner: reconnoiter 
    717777-- 
    718778 
     
    748808 
    749809 
    750 -- 
    751 -- Name: mv_loading_dock_check_s(); Type: FUNCTION; Schema: stratcon; Owner: - 
     810ALTER FUNCTION stratcon.loading_dock_status_s_change_log() OWNER TO reconnoiter; 
     811 
     812-- 
     813-- Name: mv_loading_dock_check_s(); Type: FUNCTION; Schema: stratcon; Owner: reconnoiter 
    752814-- 
    753815 
     
    785847 
    786848 
    787 -- 
    788 -- Name: remove_metric(uuid, text, text); Type: FUNCTION; Schema: stratcon; Owner: - 
     849ALTER FUNCTION stratcon.mv_loading_dock_check_s() OWNER TO reconnoiter; 
     850 
     851-- 
     852-- Name: remove_metric(uuid, text, text); Type: FUNCTION; Schema: stratcon; Owner: reconnoiter 
    789853-- 
    790854 
     
    891955 
    892956 
    893 -- 
    894 -- Name: rollup_matrix_numeric_12hours(); Type: FUNCTION; Schema: stratcon; Owner: - 
     957ALTER FUNCTION stratcon.remove_metric(in_uuid uuid, in_metric_name text, v_debug text, OUT v_out text) OWNER TO reconnoiter; 
     958 
     959-- 
     960-- Name: rollup_matrix_numeric_12hours(); Type: FUNCTION; Schema: stratcon; Owner: reconnoiter 
    895961-- 
    896962 
     
    9911057 
    9921058 
    993 -- 
    994 -- Name: rollup_matrix_numeric_20m(); Type: FUNCTION; Schema: stratcon; Owner: - 
     1059ALTER FUNCTION stratcon.rollup_matrix_numeric_12hours() OWNER TO reconnoiter; 
     1060 
     1061-- 
     1062-- Name: rollup_matrix_numeric_20m(); Type: FUNCTION; Schema: stratcon; Owner: reconnoiter 
    9951063-- 
    9961064 
     
    10951163 
    10961164 
    1097 -- 
    1098 -- Name: rollup_matrix_numeric_5m(); Type: FUNCTION; Schema: stratcon; Owner: - 
     1165ALTER FUNCTION stratcon.rollup_matrix_numeric_20m() OWNER TO reconnoiter; 
     1166 
     1167-- 
     1168-- Name: rollup_matrix_numeric_5m(); Type: FUNCTION; Schema: stratcon; Owner: reconnoiter 
    10991169-- 
    11001170 
     
    11991269 
    12001270 
    1201 -- 
    1202 -- Name: rollup_matrix_numeric_60m(); Type: FUNCTION; Schema: stratcon; Owner: - 
     1271ALTER FUNCTION stratcon.rollup_matrix_numeric_5m() OWNER TO reconnoiter; 
     1272 
     1273-- 
     1274-- Name: rollup_matrix_numeric_60m(); Type: FUNCTION; Schema: stratcon; Owner: reconnoiter 
    12031275-- 
    12041276 
     
    12971369 
    12981370 
    1299 -- 
    1300 -- Name: rollup_matrix_numeric_6hours(); Type: FUNCTION; Schema: stratcon; Owner: - 
     1371ALTER FUNCTION stratcon.rollup_matrix_numeric_60m() OWNER TO reconnoiter; 
     1372 
     1373-- 
     1374-- Name: rollup_matrix_numeric_6hours(); Type: FUNCTION; Schema: stratcon; Owner: reconnoiter 
    13011375-- 
    13021376 
     
    13951469 
    13961470 
    1397 -- 
    1398 -- Name: update_config(inet, text, timestamp with time zone, xml); Type: FUNCTION; Schema: stratcon; Owner: - 
     1471ALTER FUNCTION stratcon.rollup_matrix_numeric_6hours() OWNER TO reconnoiter; 
     1472 
     1473-- 
     1474-- Name: update_config(inet, text, timestamp with time zone, xml); Type: FUNCTION; Schema: stratcon; Owner: reconnoiter 
    13991475-- 
    14001476 
     
    14261502 
    14271503 
    1428 -- 
    1429 -- Name: seq_sid; Type: SEQUENCE; Schema: stratcon; Owner: - 
     1504ALTER FUNCTION stratcon.update_config(v_remote_address_in inet, v_node_type_in text, v_whence_in timestamp with time zone, v_config_in xml) OWNER TO reconnoiter; 
     1505 
     1506-- 
     1507-- Name: seq_sid; Type: SEQUENCE; Schema: stratcon; Owner: reconnoiter 
    14301508-- 
    14311509 
     
    14371515 
    14381516 
    1439 -- 
    1440 -- Name: current_metric_text_pkey; Type: CONSTRAINT; Schema: stratcon; Owner: -; Tablespace:  
     1517ALTER TABLE stratcon.seq_sid OWNER TO reconnoiter; 
     1518 
     1519-- 
     1520-- Name: current_metric_text_pkey; Type: CONSTRAINT; Schema: stratcon; Owner: reconnoiter; Tablespace:  
    14411521-- 
    14421522 
     
    14461526 
    14471527-- 
    1448 -- Name: current_node_config_changelog_pkey; Type: CONSTRAINT; Schema: stratcon; Owner: -; Tablespace:  
     1528-- Name: current_node_config_changelog_pkey; Type: CONSTRAINT; Schema: stratcon; Owner: reconnoiter; Tablespace:  
    14491529-- 
    14501530 
     
    14541534 
    14551535-- 
    1456 -- Name: current_node_config_pkey; Type: CONSTRAINT; Schema: stratcon; Owner: -; Tablespace:  
     1536-- Name: current_node_config_pkey; Type: CONSTRAINT; Schema: stratcon; Owner: reconnoiter; Tablespace:  
    14571537-- 
    14581538 
     
    14621542 
    14631543-- 
    1464 -- Name: loading_dock_check_s_pkey; Type: CONSTRAINT; Schema: stratcon; Owner: -; Tablespace:  
     1544-- Name: loading_dock_check_s_pkey; Type: CONSTRAINT; Schema: stratcon; Owner: reconnoiter; Tablespace:  
    14651545-- 
    14661546 
     
    14701550 
    14711551-- 
    1472 -- Name: loading_dock_metric_numeric_s_pkey; Type: CONSTRAINT; Schema: stratcon; Owner: -; Tablespace:  
     1552-- Name: loading_dock_metric_numeric_s_pkey; Type: CONSTRAINT; Schema: stratcon; Owner: reconnoiter; Tablespace:  
    14731553-- 
    14741554 
     
    14801560 
    14811561-- 
    1482 -- Name: loading_dock_metric_text_s_change_log_pkey; Type: CONSTRAINT; Schema: stratcon; Owner: -; Tablespace:  
     1562-- Name: loading_dock_metric_text_s_change_log_pkey; Type: CONSTRAINT; Schema: stratcon; Owner: reconnoiter; Tablespace:  
    14831563-- 
    14841564 
     
    14881568 
    14891569-- 
    1490 -- Name: loading_dock_metric_text_s_pkey; Type: CONSTRAINT; Schema: stratcon; Owner: -; Tablespace:  
     1570-- Name: loading_dock_metric_text_s_pkey; Type: CONSTRAINT; Schema: stratcon; Owner: reconnoiter; Tablespace:  
    14911571-- 
    14921572 
     
    14961576 
    14971577-- 
    1498 -- Name: loading_dock_status_s_change_log_pkey; Type: CONSTRAINT; Schema: stratcon; Owner: -; Tablespace:  
     1578-- Name: loading_dock_status_s_change_log_pkey; Type: CONSTRAINT; Schema: stratcon; Owner: reconnoiter; Tablespace:  
    14991579-- 
    15001580 
     
    15041584 
    15051585-- 
    1506 -- Name: loading_dock_status_s_pkey; Type: CONSTRAINT; Schema: stratcon; Owner: -; Tablespace:  
     1586-- Name: loading_dock_status_s_pkey; Type: CONSTRAINT; Schema: stratcon; Owner: reconnoiter; Tablespace:  
    15071587-- 
    15081588 
     
    15121592 
    15131593-- 
    1514 -- Name: log_whence_s_pkey; Type: CONSTRAINT; Schema: stratcon; Owner: -; Tablespace:  
     1594-- Name: log_whence_s_pkey; Type: CONSTRAINT; Schema: stratcon; Owner: reconnoiter; Tablespace:  
    15151595-- 
    15161596 
     
    15201600 
    15211601-- 
    1522 -- Name: map_uuid_to_sid_pkey; Type: CONSTRAINT; Schema: stratcon; Owner: -; Tablespace:  
     1602-- Name: map_uuid_to_sid_pkey; Type: CONSTRAINT; Schema: stratcon; Owner: reconnoiter; Tablespace:  
    15231603-- 
    15241604 
     
    15281608 
    15291609-- 
    1530 -- Name: metric_name_summary_pk; Type: CONSTRAINT; Schema: stratcon; Owner: -; Tablespace:  
     1610-- Name: metric_name_summary_pk; Type: CONSTRAINT; Schema: stratcon; Owner: reconnoiter; Tablespace:  
    15311611-- 
    15321612 
     
    15361616 
    15371617-- 
    1538 -- Name: mv_loading_dock_check_s_pkey; Type: CONSTRAINT; Schema: stratcon; Owner: -; Tablespace:  
     1618-- Name: mv_loading_dock_check_s_pkey; Type: CONSTRAINT; Schema: stratcon; Owner: reconnoiter; Tablespace:  
    15391619-- 
    15401620 
     
    15441624 
    15451625-- 
    1546 -- Name: rollup_matrix_numeric_12hours_pkey; Type: CONSTRAINT; Schema: stratcon; Owner: -; Tablespace:  
     1626-- Name: rollup_matrix_numeric_12hours_pkey; Type: CONSTRAINT; Schema: stratcon; Owner: reconnoiter; Tablespace:  
    15471627-- 
    15481628 
     
    15541634 
    15551635-- 
    1556 -- Name: rollup_matrix_numeric_20m_new_pkey; Type: CONSTRAINT; Schema: stratcon; Owner: -; Tablespace:  
     1636-- Name: rollup_matrix_numeric_20m_new_pkey; Type: CONSTRAINT; Schema: stratcon; Owner: reconnoiter; Tablespace:  
    15571637-- 
    15581638 
     
    15641644 
    15651645-- 
    1566 -- Name: rollup_matrix_numeric_5m_pkey; Type: CONSTRAINT; Schema: stratcon; Owner: -; Tablespace:  
     1646-- Name: rollup_matrix_numeric_5m_pkey; Type: CONSTRAINT; Schema: stratcon; Owner: reconnoiter; Tablespace:  
    15671647-- 
    15681648 
     
    15741654 
    15751655-- 
    1576 -- Name: rollup_matrix_numeric_60m_pkey; Type: CONSTRAINT; Schema: stratcon; Owner: -; Tablespace:  
     1656-- Name: rollup_matrix_numeric_60m_pkey; Type: CONSTRAINT; Schema: stratcon; Owner: reconnoiter; Tablespace:  
    15771657-- 
    15781658 
     
    15841664 
    15851665-- 
    1586 -- Name: rollup_matrix_numeric_6hours_pkey; Type: CONSTRAINT; Schema: stratcon; Owner: -; Tablespace:  
     1666-- Name: rollup_matrix_numeric_6hours_pkey; Type: CONSTRAINT; Schema: stratcon; Owner: reconnoiter; Tablespace:  
    15871667-- 
    15881668 
     
    15941674 
    15951675-- 
    1596 -- Name: idx_mv_loading_dock_check_s_module; Type: INDEX; Schema: stratcon; Owner: -; Tablespace:  
     1676-- Name: idx_mv_loading_dock_check_s_module; Type: INDEX; Schema: stratcon; Owner: reconnoiter; Tablespace:  
    15971677-- 
    15981678 
     
    16011681 
    16021682-- 
    1603 -- Name: idx_mv_loading_dock_check_s_name; Type: INDEX; Schema: stratcon; Owner: -; Tablespace:  
     1683-- Name: idx_mv_loading_dock_check_s_name; Type: INDEX; Schema: stratcon; Owner: reconnoiter; Tablespace:  
    16041684-- 
    16051685 
     
    16081688 
    16091689-- 
    1610 -- Name: idx_mv_loading_dock_check_s_target; Type: INDEX; Schema: stratcon; Owner: -; Tablespace:  
     1690-- Name: idx_mv_loading_dock_check_s_target; Type: INDEX; Schema: stratcon; Owner: reconnoiter; Tablespace:  
    16111691-- 
    16121692 
     
    16151695 
    16161696-- 
    1617 -- Name: idx_rollup_matrix_numeric_20m_rollup_time; Type: INDEX; Schema: stratcon; Owner: -; Tablespace:  
     1697-- Name: idx_rollup_matrix_numeric_20m_rollup_time; Type: INDEX; Schema: stratcon; Owner: reconnoiter; Tablespace:  
    16181698-- 
    16191699 
     
    16221702 
    16231703-- 
    1624 -- Name: unq_mv_loading_dock_check_s_id; Type: INDEX; Schema: stratcon; Owner: -; Tablespace:  
     1704-- Name: unq_mv_loading_dock_check_s_id; Type: INDEX; Schema: stratcon; Owner: reconnoiter; Tablespace:  
    16251705-- 
    16261706 
     
    16291709 
    16301710-- 
    1631 -- Name: loading_dock_metric_numeric_s_whence_log; Type: TRIGGER; Schema: stratcon; Owner: - 
     1711-- Name: loading_dock_metric_numeric_s_whence_log; Type: TRIGGER; Schema: stratcon; Owner: reconnoiter 
    16321712-- 
    16331713 
     
    16391719 
    16401720-- 
    1641 -- Name: loading_dock_metric_text_s_change_log; Type: TRIGGER; Schema: stratcon; Owner: - 
     1721-- Name: loading_dock_metric_text_s_change_log; Type: TRIGGER; Schema: stratcon; Owner: reconnoiter 
    16421722-- 
    16431723 
     
    16491729 
    16501730-- 
    1651 -- Name: loading_dock_status_s_change_log; Type: TRIGGER; Schema: stratcon; Owner: - 
     1731-- Name: loading_dock_status_s_change_log; Type: TRIGGER; Schema: stratcon; Owner: reconnoiter 
    16521732-- 
    16531733 
     
    16591739 
    16601740-- 
    1661 -- Name: mv_loading_dock_check_s; Type: TRIGGER; Schema: stratcon; Owner: - 
     1741-- Name: mv_loading_dock_check_s; Type: TRIGGER; Schema: stratcon; Owner: reconnoiter 
    16621742-- 
    16631743 
     
    16691749 
    16701750-- 
    1671 -- Name: stratcon; Type: ACL; Schema: -; Owner: - 
     1751-- Name: stratcon; Type: ACL; Schema: -; Owner: omniti 
    16721752-- 
    16731753 
     
    16761756GRANT ALL ON SCHEMA stratcon TO omniti; 
    16771757GRANT USAGE ON SCHEMA stratcon TO stratcon; 
    1678  
    1679  
    1680 -- 
    1681 -- Name: loading_dock_check_s; Type: ACL; Schema: stratcon; Owner: - 
     1758GRANT USAGE ON SCHEMA stratcon TO prism; 
     1759 
     1760 
     1761-- 
     1762-- Name: current_metric_text; Type: ACL; Schema: stratcon; Owner: reconnoiter 
     1763-- 
     1764 
     1765REVOKE ALL ON TABLE current_metric_text FROM PUBLIC; 
     1766REVOKE ALL ON TABLE current_metric_text FROM reconnoiter; 
     1767GRANT ALL ON TABLE current_metric_text TO reconnoiter; 
     1768GRANT SELECT ON TABLE current_metric_text TO prism; 
     1769GRANT SELECT,INSERT,UPDATE ON TABLE current_metric_text TO stratcon; 
     1770 
     1771 
     1772-- 
     1773-- Name: current_node_config; Type: ACL; Schema: stratcon; Owner: reconnoiter 
     1774-- 
     1775 
     1776REVOKE ALL ON TABLE current_node_config FROM PUBLIC; 
     1777REVOKE ALL ON TABLE current_node_config FROM reconnoiter; 
     1778GRANT ALL ON TABLE current_node_config TO reconnoiter; 
     1779GRANT SELECT ON TABLE current_node_config TO prism; 
     1780GRANT SELECT,INSERT,UPDATE ON TABLE current_node_config TO stratcon; 
     1781 
     1782 
     1783-- 
     1784-- Name: current_node_config_changelog; Type: ACL; Schema: stratcon; Owner: reconnoiter 
     1785-- 
     1786 
     1787REVOKE ALL ON TABLE current_node_config_changelog FROM PUBLIC; 
     1788REVOKE ALL ON TABLE current_node_config_changelog FROM reconnoiter; 
     1789GRANT ALL ON TABLE current_node_config_changelog TO reconnoiter; 
     1790GRANT SELECT ON TABLE current_node_config_changelog TO prism; 
     1791GRANT SELECT,INSERT,UPDATE ON TABLE current_node_config_changelog TO stratcon; 
     1792 
     1793 
     1794-- 
     1795-- Name: loading_dock_check_s; Type: ACL; Schema: stratcon; Owner: reconnoiter 
    16821796-- 
    16831797 
    16841798REVOKE ALL ON TABLE loading_dock_check_s FROM PUBLIC; 
    1685 REVOKE ALL ON TABLE loading_dock_check_s FROM omniti; 
    1686 GRANT ALL ON TABLE loading_dock_check_s TO omniti; 
    1687 GRANT SELECT,INSERT ON TABLE loading_dock_check_s TO stratcon; 
    1688  
    1689  
    1690 -- 
    1691 -- Name: loading_dock_metric_numeric_s; Type: ACL; Schema: stratcon; Owner: - 
     1799REVOKE ALL ON TABLE loading_dock_check_s FROM reconnoiter; 
     1800GRANT ALL ON TABLE loading_dock_check_s TO reconnoiter; 
     1801GRANT SELECT,INSERT,UPDATE ON TABLE loading_dock_check_s TO stratcon; 
     1802GRANT SELECT ON TABLE loading_dock_check_s TO prism; 
     1803 
     1804 
     1805-- 
     1806-- Name: loading_dock_metric_numeric_s; Type: ACL; Schema: stratcon; Owner: reconnoiter 
    16921807-- 
    16931808 
    16941809REVOKE ALL ON TABLE loading_dock_metric_numeric_s FROM PUBLIC; 
    1695 REVOKE ALL ON TABLE loading_dock_metric_numeric_s FROM omniti; 
    1696 GRANT ALL ON TABLE loading_dock_metric_numeric_s TO omniti; 
    1697 GRANT SELECT,INSERT ON TABLE loading_dock_metric_numeric_s TO stratcon; 
    1698  
    1699  
    1700 -- 
    1701 -- Name: loading_dock_metric_text_s; Type: ACL; Schema: stratcon; Owner: - 
     1810REVOKE ALL ON TABLE loading_dock_metric_numeric_s FROM reconnoiter; 
     1811GRANT ALL ON TABLE loading_dock_metric_numeric_s TO reconnoiter; 
     1812GRANT SELECT,INSERT,UPDATE ON TABLE loading_dock_metric_numeric_s TO stratcon; 
     1813GRANT SELECT ON TABLE loading_dock_metric_numeric_s TO prism; 
     1814 
     1815 
     1816-- 
     1817-- Name: loading_dock_metric_text_s; Type: ACL; Schema: stratcon; Owner: reconnoiter 
    17021818-- 
    17031819 
    17041820REVOKE ALL ON TABLE loading_dock_metric_text_s FROM PUBLIC; 
    1705 REVOKE ALL ON TABLE loading_dock_metric_text_s FROM omniti; 
    1706 GRANT ALL ON TABLE loading_dock_metric_text_s TO omniti; 
    1707 GRANT SELECT,INSERT,DELETE ON TABLE loading_dock_metric_text_s TO stratcon; 
    1708  
    1709  
    1710 -- 
    1711 -- Name: loading_dock_metric_text_s_change_log; Type: ACL; Schema: stratcon; Owner: - 
     1821REVOKE ALL ON TABLE loading_dock_metric_text_s FROM reconnoiter; 
     1822GRANT ALL ON TABLE loading_dock_metric_text_s TO reconnoiter; 
     1823GRANT SELECT,INSERT,DELETE,UPDATE ON TABLE loading_dock_metric_text_s TO stratcon; 
     1824GRANT SELECT ON TABLE loading_dock_metric_text_s TO prism; 
     1825 
     1826 
     1827-- 
     1828-- Name: loading_dock_metric_text_s_change_log; Type: ACL; Schema: stratcon; Owner: reconnoiter 
    17121829-- 
    17131830 
    17141831REVOKE ALL ON TABLE loading_dock_metric_text_s_change_log FROM PUBLIC; 
    1715 REVOKE ALL ON TABLE loading_dock_metric_text_s_change_log FROM omniti; 
    1716 GRANT ALL ON TABLE loading_dock_metric_text_s_change_log TO omniti; 
    1717 GRANT SELECT,INSERT ON TABLE loading_dock_metric_text_s_change_log TO stratcon; 
    1718  
    1719  
    1720 -- 
    1721 -- Name: loading_dock_status_s; Type: ACL; Schema: stratcon; Owner: - 
     1832REVOKE ALL ON TABLE loading_dock_metric_text_s_change_log FROM reconnoiter; 
     1833GRANT ALL ON TABLE loading_dock_metric_text_s_change_log TO reconnoiter; 
     1834GRANT SELECT,INSERT,UPDATE ON TABLE loading_dock_metric_text_s_change_log TO stratcon; 
     1835GRANT SELECT ON TABLE loading_dock_metric_text_s_change_log TO prism; 
     1836 
     1837 
     1838-- 
     1839-- Name: loading_dock_status_s; Type: ACL; Schema: stratcon; Owner: reconnoiter 
    17221840-- 
    17231841 
    17241842REVOKE ALL ON TABLE loading_dock_status_s FROM PUBLIC; 
    1725 REVOKE ALL ON TABLE loading_dock_status_s FROM omniti; 
    1726 GRANT ALL ON TABLE loading_dock_status_s TO omniti; 
    1727 GRANT SELECT,INSERT ON TABLE loading_dock_status_s TO stratcon; 
    1728  
    1729  
    1730 -- 
    1731 -- Name: loading_dock_status_s_change_log; Type: ACL; Schema: stratcon; Owner: - 
     1843REVOKE ALL ON TABLE loading_dock_status_s FROM reconnoiter; 
     1844GRANT ALL ON TABLE loading_dock_status_s TO reconnoiter; 
     1845GRANT SELECT,INSERT,UPDATE ON TABLE loading_dock_status_s TO stratcon; 
     1846GRANT SELECT ON TABLE loading_dock_status_s TO prism; 
     1847 
     1848 
     1849-- 
     1850-- Name: loading_dock_status_s_change_log; Type: ACL; Schema: stratcon; Owner: reconnoiter 
    17321851-- 
    17331852 
    17341853REVOKE ALL ON TABLE loading_dock_status_s_change_log FROM PUBLIC; 
    1735 REVOKE ALL ON TABLE loading_dock_status_s_change_log FROM omniti; 
    1736 GRANT ALL ON TABLE loading_dock_status_s_change_log TO omniti; 
    1737 GRANT SELECT,INSERT,DELETE ON TABLE loading_dock_status_s_change_log TO stratcon; 
    1738  
    1739  
    1740 -- 
    1741 -- Name: log_whence_s; Type: ACL; Schema: stratcon; Owner: - 
     1854REVOKE ALL ON TABLE loading_dock_status_s_change_log FROM reconnoiter; 
     1855GRANT ALL ON TABLE loading_dock_status_s_change_log TO reconnoiter; 
     1856GRANT SELECT,INSERT,DELETE,UPDATE ON TABLE loading_dock_status_s_change_log TO stratcon; 
     1857GRANT SELECT ON TABLE loading_dock_status_s_change_log TO prism; 
     1858 
     1859 
     1860-- 
     1861-- Name: log_whence_s; Type: ACL; Schema: stratcon; Owner: reconnoiter 
    17421862-- 
    17431863 
    17441864REVOKE ALL ON TABLE log_whence_s FROM PUBLIC; 
    1745 REVOKE ALL ON TABLE log_whence_s FROM omniti
    1746 GRANT ALL ON TABLE log_whence_s TO omniti
     1865REVOKE ALL ON TABLE log_whence_s FROM reconnoiter
     1866GRANT ALL ON TABLE log_whence_s TO reconnoiter
    17471867GRANT SELECT,INSERT,DELETE,UPDATE ON TABLE log_whence_s TO stratcon; 
    1748  
    1749  
    1750 -- 
    1751 -- Name: map_uuid_to_sid; Type: ACL; Schema: stratcon; Owner: - 
     1868GRANT SELECT ON TABLE log_whence_s TO prism; 
     1869 
     1870 
     1871-- 
     1872-- Name: map_uuid_to_sid; Type: ACL; Schema: stratcon; Owner: reconnoiter 
    17521873-- 
    17531874 
    17541875REVOKE ALL ON TABLE map_uuid_to_sid FROM PUBLIC; 
    1755 REVOKE ALL ON TABLE map_uuid_to_sid FROM omniti; 
    1756 GRANT ALL ON TABLE map_uuid_to_sid TO omniti; 
    1757 GRANT SELECT,INSERT ON TABLE map_uuid_to_sid TO stratcon; 
    1758  
    1759  
    1760 -- 
    1761 -- Name: metric_name_summary; Type: ACL; Schema: stratcon; Owner: - 
     1876REVOKE ALL ON TABLE map_uuid_to_sid FROM reconnoiter; 
     1877GRANT ALL ON TABLE map_uuid_to_sid TO reconnoiter; 
     1878GRANT SELECT,INSERT,UPDATE ON TABLE map_uuid_to_sid TO stratcon; 
     1879GRANT SELECT ON TABLE map_uuid_to_sid TO prism; 
     1880 
     1881 
     1882-- 
     1883-- Name: metric_name_summary; Type: ACL; Schema: stratcon; Owner: reconnoiter 
    17621884-- 
    17631885 
    17641886REVOKE ALL ON TABLE metric_name_summary FROM PUBLIC; 
    1765 REVOKE ALL ON TABLE metric_name_summary FROM omniti
    1766 GRANT ALL ON TABLE metric_name_summary TO omniti
     1887REVOKE ALL ON TABLE metric_name_summary FROM reconnoiter
     1888GRANT ALL ON TABLE metric_name_summary TO reconnoiter
    17671889GRANT SELECT,INSERT,DELETE,UPDATE ON TABLE metric_name_summary TO stratcon; 
    1768  
    1769  
    1770 -- 
    1771 -- Name: rollup_matrix_numeric_12hours; Type: ACL; Schema: stratcon; Owner: - 
     1890GRANT SELECT ON TABLE metric_name_summary TO prism; 
     1891 
     1892 
     1893-- 
     1894-- Name: mv_loading_dock_check_s; Type: ACL; Schema: stratcon; Owner: reconnoiter 
     1895-- 
     1896 
     1897REVOKE ALL ON TABLE mv_loading_dock_check_s FROM PUBLIC; 
     1898REVOKE ALL ON TABLE mv_loading_dock_check_s FROM reconnoiter; 
     1899GRANT ALL ON TABLE mv_loading_dock_check_s TO reconnoiter; 
     1900GRANT SELECT ON TABLE mv_loading_dock_check_s TO prism; 
     1901GRANT SELECT,INSERT,DELETE,UPDATE ON TABLE mv_loading_dock_check_s TO stratcon; 
     1902 
     1903 
     1904-- 
     1905-- Name: rollup_matrix_numeric_12hours; Type: ACL; Schema: stratcon; Owner: reconnoiter 
    17721906-- 
    17731907 
    17741908REVOKE ALL ON TABLE rollup_matrix_numeric_12hours FROM PUBLIC; 
    1775 REVOKE ALL ON TABLE rollup_matrix_numeric_12hours FROM postgres
    1776 GRANT ALL ON TABLE rollup_matrix_numeric_12hours TO postgres
     1909REVOKE ALL ON TABLE rollup_matrix_numeric_12hours FROM reconnoiter
     1910GRANT ALL ON TABLE rollup_matrix_numeric_12hours TO reconnoiter
    17771911GRANT SELECT,INSERT,DELETE ON TABLE rollup_matrix_numeric_12hours TO stratcon; 
    1778 GRANT SELECT,INSERT,DELETE ON TABLE rollup_matrix_numeric_12hours TO omniti
    1779  
    1780  
    1781 -- 
    1782 -- Name: rollup_matrix_numeric_20m; Type: ACL; Schema: stratcon; Owner: - 
     1912GRANT SELECT ON TABLE rollup_matrix_numeric_12hours TO prism
     1913 
     1914 
     1915-- 
     1916-- Name: rollup_matrix_numeric_20m; Type: ACL; Schema: stratcon; Owner: reconnoiter 
    17831917-- 
    17841918 
    17851919REVOKE ALL ON TABLE rollup_matrix_numeric_20m FROM PUBLIC; 
    1786 REVOKE ALL ON TABLE rollup_matrix_numeric_20m FROM omniti
    1787 GRANT ALL ON TABLE rollup_matrix_numeric_20m TO omniti
     1920REVOKE ALL ON TABLE rollup_matrix_numeric_20m FROM reconnoiter
     1921GRANT ALL ON TABLE rollup_matrix_numeric_20m TO reconnoiter
    17881922GRANT SELECT,INSERT,DELETE ON TABLE rollup_matrix_numeric_20m TO stratcon; 
    1789  
    1790  
    1791 -- 
    1792 -- Name: rollup_matrix_numeric_5m; Type: ACL; Schema: stratcon; Owner: - 
     1923GRANT SELECT ON TABLE rollup_matrix_numeric_20m TO prism; 
     1924 
     1925 
     1926-- 
     1927-- Name: rollup_matrix_numeric_5m; Type: ACL; Schema: stratcon; Owner: reconnoiter 
    17931928-- 
    17941929 
    17951930REVOKE ALL ON TABLE rollup_matrix_numeric_5m FROM PUBLIC; 
    1796 REVOKE ALL ON TABLE rollup_matrix_numeric_5m FROM omniti
    1797 GRANT ALL ON TABLE rollup_matrix_numeric_5m TO omniti
     1931REVOKE ALL ON TABLE rollup_matrix_numeric_5m FROM reconnoiter
     1932GRANT ALL ON TABLE rollup_matrix_numeric_5m TO reconnoiter
    17981933GRANT SELECT,INSERT,DELETE ON TABLE rollup_matrix_numeric_5m TO stratcon; 
    1799  
    1800  
    1801 -- 
    1802 -- Name: rollup_matrix_numeric_60m; Type: ACL; Schema: stratcon; Owner: - 
     1934GRANT SELECT ON TABLE rollup_matrix_numeric_5m TO prism; 
     1935 
     1936 
     1937-- 
     1938-- Name: rollup_matrix_numeric_60m; Type: ACL; Schema: stratcon; Owner: reconnoiter 
    18031939-- 
    18041940 
    18051941REVOKE ALL ON TABLE rollup_matrix_numeric_60m FROM PUBLIC; 
    1806 REVOKE ALL ON TABLE rollup_matrix_numeric_60m FROM omniti
    1807 GRANT ALL ON TABLE rollup_matrix_numeric_60m TO omniti
     1942REVOKE ALL ON TABLE rollup_matrix_numeric_60m FROM reconnoiter
     1943GRANT ALL ON TABLE rollup_matrix_numeric_60m TO reconnoiter
    18081944GRANT SELECT,INSERT,DELETE ON TABLE rollup_matrix_numeric_60m TO stratcon; 
    1809  
    1810  
    1811 -- 
    1812 -- Name: rollup_matrix_numeric_6hours; Type: ACL; Schema: stratcon; Owner: - 
     1945GRANT SELECT ON TABLE rollup_matrix_numeric_60m TO prism; 
     1946 
     1947 
     1948-- 
     1949-- Name: rollup_matrix_numeric_6hours; Type: ACL; Schema: stratcon; Owner: reconnoiter 
    18131950-- 
    18141951 
    18151952REVOKE ALL ON TABLE rollup_matrix_numeric_6hours FROM PUBLIC; 
    1816 REVOKE ALL ON TABLE rollup_matrix_numeric_6hours FROM omniti
    1817 GRANT ALL ON TABLE rollup_matrix_numeric_6hours TO omniti
     1953REVOKE ALL ON TABLE rollup_matrix_numeric_6hours FROM reconnoiter
     1954GRANT ALL ON TABLE rollup_matrix_numeric_6hours TO reconnoiter
    18181955GRANT SELECT,INSERT,DELETE ON TABLE rollup_matrix_numeric_6hours TO stratcon; 
    1819  
    1820  
    1821 -- 
    1822 -- Name: rollup_runner; Type: ACL; Schema: stratcon; Owner: - 
     1956GRANT SELECT ON TABLE rollup_matrix_numeric_6hours TO prism; 
     1957 
     1958 
     1959-- 
     1960-- Name: rollup_runner; Type: ACL; Schema: stratcon; Owner: reconnoiter 
    18231961-- 
    18241962 
    18251963REVOKE ALL ON TABLE rollup_runner FROM PUBLIC; 
    1826 REVOKE ALL ON TABLE rollup_runner FROM omniti
    1827 GRANT ALL ON TABLE rollup_runner TO omniti
     1964REVOKE ALL ON TABLE rollup_runner FROM reconnoiter
     1965GRANT ALL ON TABLE rollup_runner TO reconnoiter
    18281966GRANT SELECT,INSERT,DELETE,UPDATE ON TABLE rollup_runner TO stratcon; 
     1967GRANT SELECT ON TABLE rollup_runner TO prism; 
     1968 
     1969 
     1970-- 
     1971-- Name: seq_sid; Type: ACL; Schema: stratcon; Owner: reconnoiter 
     1972-- 
     1973 
     1974REVOKE ALL ON SEQUENCE seq_sid FROM PUBLIC; 
     1975REVOKE ALL ON SEQUENCE seq_sid FROM reconnoiter; 
     1976GRANT ALL ON SEQUENCE seq_sid TO reconnoiter; 
     1977GRANT ALL ON SEQUENCE seq_sid TO stratcon; 
    18291978 
    18301979