SCS Archiver CS-Studio PostgreSQL GSI Overall Scheme CSS_EE

PostgresQL scheme of css_ee at GSI

-- Schema: css_ee

-- DROP SCHEMA css_ee;

CREATE SCHEMA css_ee
  AUTHORIZATION admin_tb;

GRANT ALL ON SCHEMA css_ee TO admin_tb;
GRANT ALL ON SCHEMA css_ee TO admin_sh;
GRANT ALL ON SCHEMA css_ee TO admin_sj;
GRANT ALL ON SCHEMA css_ee TO pzumbruch;
GRANT ALL ON SCHEMA css_ee TO "p.zumbruch";
GRANT USAGE ON SCHEMA css_ee TO epics;

ALTER DEFAULT PRIVILEGES IN SCHEMA css_ee
    GRANT INSERT, SELECT, UPDATE, DELETE, TRUNCATE, REFERENCES, TRIGGER ON TABLES
    TO admin_sh;

ALTER DEFAULT PRIVILEGES IN SCHEMA css_ee
    GRANT INSERT, SELECT, UPDATE, DELETE, TRUNCATE, REFERENCES, TRIGGER ON TABLES
    TO admin_sj;

ALTER DEFAULT PRIVILEGES IN SCHEMA css_ee
    GRANT INSERT, SELECT, UPDATE, DELETE, TRUNCATE, REFERENCES, TRIGGER ON TABLES
    TO admin_tb;

ALTER DEFAULT PRIVILEGES IN SCHEMA css_ee
    GRANT INSERT, SELECT, UPDATE, DELETE, TRUNCATE, REFERENCES, TRIGGER ON TABLES
    TO "p.zumbruch";

ALTER DEFAULT PRIVILEGES IN SCHEMA css_ee
    GRANT INSERT, SELECT, UPDATE, DELETE, TRUNCATE, REFERENCES, TRIGGER ON TABLES
    TO pzumbruch;

ALTER DEFAULT PRIVILEGES IN SCHEMA css_ee
    GRANT INSERT, SELECT, UPDATE, DELETE, TRUNCATE, REFERENCES, TRIGGER ON TABLES
    TO epics;

ALTER DEFAULT PRIVILEGES IN SCHEMA css_ee
    GRANT SELECT, UPDATE, USAGE ON SEQUENCES
    TO admin_sh;

ALTER DEFAULT PRIVILEGES IN SCHEMA css_ee
    GRANT SELECT, UPDATE, USAGE ON SEQUENCES
    TO admin_sj;

ALTER DEFAULT PRIVILEGES IN SCHEMA css_ee
    GRANT SELECT, UPDATE, USAGE ON SEQUENCES
    TO admin_tb;

ALTER DEFAULT PRIVILEGES IN SCHEMA css_ee
    GRANT SELECT, UPDATE, USAGE ON SEQUENCES
    TO "p.zumbruch";

ALTER DEFAULT PRIVILEGES IN SCHEMA css_ee
    GRANT SELECT, UPDATE, USAGE ON SEQUENCES
    TO pzumbruch;

ALTER DEFAULT PRIVILEGES IN SCHEMA css_ee
    GRANT SELECT, UPDATE, USAGE ON SEQUENCES
    TO epics;

ALTER DEFAULT PRIVILEGES IN SCHEMA css_ee
    GRANT EXECUTE ON FUNCTIONS
    TO admin_sh;

ALTER DEFAULT PRIVILEGES IN SCHEMA css_ee
    GRANT EXECUTE ON FUNCTIONS
    TO admin_sj;

ALTER DEFAULT PRIVILEGES IN SCHEMA css_ee
    GRANT EXECUTE ON FUNCTIONS
    TO admin_tb;

ALTER DEFAULT PRIVILEGES IN SCHEMA css_ee
    GRANT EXECUTE ON FUNCTIONS
    TO "p.zumbruch";

ALTER DEFAULT PRIVILEGES IN SCHEMA css_ee
    GRANT EXECUTE ON FUNCTIONS
    TO pzumbruch;

ALTER DEFAULT PRIVILEGES IN SCHEMA css_ee
    GRANT EXECUTE ON FUNCTIONS
    TO epics;

ALTER DEFAULT PRIVILEGES IN SCHEMA css_ee
    GRANT USAGE ON TYPES
    TO admin_sh;

ALTER DEFAULT PRIVILEGES IN SCHEMA css_ee
    GRANT USAGE ON TYPES
    TO admin_sj;

ALTER DEFAULT PRIVILEGES IN SCHEMA css_ee
    GRANT USAGE ON TYPES
    TO admin_tb;

ALTER DEFAULT PRIVILEGES IN SCHEMA css_ee
    GRANT USAGE ON TYPES
    TO "p.zumbruch";

ALTER DEFAULT PRIVILEGES IN SCHEMA css_ee
    GRANT USAGE ON TYPES
    TO pzumbruch;

ALTER DEFAULT PRIVILEGES IN SCHEMA css_ee
    GRANT USAGE ON TYPES
    TO epics;


-- PeterZumbruch - 18 Dec 2015
Topic revision: r1 - 18 Dec 2015, PeterZumbruch
 
This site is powered by FoswikiCopyright © by the contributing authors. All material on this collaboration platform is the property of the contributing authors.
Ideas, requests, problems regarding Hades Wiki? Send feedback
Imprint (in German)
Privacy Policy (in German)