SCS Archiver CS-Studio PostgreSQL GSI Overall Scheme CSS_EE

PostgresQL scheme of css_ee at GSI

%CODE{"plsql"}% -- 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; %ENDCODE%

---

-- PeterZumbruch - 18 Dec 2015