File indexing completed on 2026-04-09 07:58:17
0001 CREATE USER doma_idds_r WITH PASSWORD 'test_idds';
0002 GRANT CONNECT ON DATABASE doma_idds TO doma_idds_r;
0003 GRANT USAGE ON SCHEMA doma_idds TO doma_idds_r;
0004 GRANT SELECT ON ALL TABLES IN SCHEMA doma_idds TO doma_idds_r;
0005 ALTER DEFAULT PRIVILEGES IN SCHEMA doma_idds GRANT SELECT ON TABLES TO doma_idds_r;
0006
0007 CREATE USER doma_idds WITH PASSWORD 'test_idds_pass';
0008 create database doma_idds;
0009 \connect doma_idds;
0010 create schema if not exists doma_idds authorization doma_idds;
0011 GRANT CONNECT ON DATABASE doma_idds TO doma_idds;
0012 GRANT USAGE ON SCHEMA doma_idds TO doma_idds;
0013 GRANT ALL PRIVILEGES ON ALL TABLES IN SCHEMA doma_idds TO doma_idds;
0014 GRANT ALL PRIVILEGES ON ALL SEQUENCES IN SCHEMA doma_idds TO doma_idds;
0015 GRANT ALL PRIVILEGES ON DATABASE doma_idds TO doma_idds;
0016 #ALTER DEFAULT PRIVILEGES IN SCHEMA doma_idds GRANT SELECT ON TABLES TO doma_idds;
0017
0018 set search_path to doma_idds;
