Changeset 9f9d948f5f91f25c6ec5d43a5ddcd1143e30fd45

Show
Ignore:
Timestamp:
09/22/08 18:00:45 (5 years ago)
Author:
Denish Patel <denish@omniti.com>
git-committer:
Denish Patel <denish@omniti.com> 1222106445 +0000
git-parent:

[70d8a8f096162b8f5ef06f5668066b9e7e942814]

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

pg ddl update-- alter schema statrcon owner to reconnoiter

Files:

Legend:

Unmodified
Added
Removed
Modified
Copied
Moved

  • sql/reconnoiter_ddl_dump.sql

    r70d8a8f r9f9d948  
    1010 
    1111-- 
    12 -- Name: stratcon; Type: SCHEMA; Schema: -; Owner: omniti 
     12-- Name: stratcon; Type: SCHEMA; Schema: -; Owner: reconnoiter 
    1313-- 
    1414 
    …… 
    1616 
    1717 
    18 ALTER SCHEMA stratcon OWNER TO omniti; 
     18ALTER SCHEMA stratcon OWNER TO reconnoiter; 
    1919 
    2020SET search_path = stratcon, pg_catalog; 
    …… 
    17491749 
    17501750-- 
    1751 -- Name: stratcon; Type: ACL; Schema: -; Owner: omniti 
     1751-- Name: stratcon; Type: ACL; Schema: -; Owner: reconnoiter 
    17521752-- 
    17531753 
    17541754REVOKE ALL ON SCHEMA stratcon FROM PUBLIC; 
    1755 REVOKE ALL ON SCHEMA stratcon FROM omniti; 
    1756 GRANT ALL ON SCHEMA stratcon TO omniti; 
     1755REVOKE ALL ON SCHEMA stratcon FROM reconnoiter; 
     1756GRANT ALL ON SCHEMA stratcon TO reconnoiter; 
    17571757GRANT USAGE ON SCHEMA stratcon TO stratcon; 
    17581758GRANT USAGE ON SCHEMA stratcon TO prism;