d934cFiZ

1  CREATE ROLE lcm_admin LOGIN
2  ENCRYPTED PASSWORD 'md5b626289c1d6072fa3386c7a880cccdcb'
3  SUPERUSER INHERIT CREATEDB CREATEROLE NOREPLICATION CONNECTION LIMIT 2;
4  
5  CREATE ROLE dermacon_lcm LOGIN
6  ENCRYPTED PASSWORD 'md5a75545e3f6eccf13604b2fc378a386d4'
7  NOSUPERUSER NOINHERIT NOCREATEDB NOCREATEROLE NOREPLICATION;
8
9CREATE SCHEMA IF NOT EXISTS lcm;
10
11ALTER SCHEMA lcm OWNER TO lcm_admin;
12
13GRANT USAGE ON SCHEMA lcm TO dermacon_lcm;
14ALTER DEFAULT PRIVILEGES IN SCHEMA lcm GRANT SELECT, INSERT, UPDATE, DELETE ON TABLES TO dermacon_lcm;
15ALTER DEFAULT PRIVILEGES IN SCHEMA lcm GRANT SELECT, UPDATE, USAGE ON sequences TO dermacon_lcm;
16
17
18CREATE SEQUENCE factories_id_seq
19    START WITH 1
20    INCREMENT BY 1
21    NO MINVALUE
22    NO MAXVALUE
23    CACHE 1;
24
25
26ALTER TABLE factories_id_seq OWNER TO lcm_admin;