Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- CREATE EXTENSION PostGIS
- CREATE ROLE user_group_name NOSUPERUSER INHERIT NOCREATEDB NOCREATEROLE NOREPLICATION;
- CREATE ROLE admin_group_name NOSUPERUSER INHERIT NOCREATEDB NOCREATEROLE NOREPLICATION;
- GRANT user_group_name TO admin_group_name
- GRANT ALL ON DATABASE database_name TO admin_group_name;
- CREATE ROLE admin_name LOGIN PASSWORD 'their_password' NOSUPERUSER INHERIT NOCREATEDB NOCREATEROLE NOREPLICATION;
- GRANT admin_group_name TO admin_name;
- CREATE ROLE user_name LOGIN PASSWORD 'their_password' NOSUPERUSER INHERIT NOCREATEDB NOCREATEROLE NOREPLICATION;
- GRANT users_group_name TO user_name;
- GRANT ALL ON SCHEMA schema_name TO admin_group_name;
- GRANT USAGE ON SCHEMA schema TO user_group_name;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement