Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- CREATE DATABASE db;
- CREATE USER user WITH ENCRYPTED PASSWORD 'xxxx-oooo';
- \c db;
- GRANT ALL PRIVILEGES ON DATABASE db TO user;
- GRANT USAGE ON SCHEMA public TO user ;
- ALTER DEFAULT PRIVILEGES IN SCHEMA public GRANT ALL ON TABLES TO user;
- ALTER DEFAULT PRIVILEGES IN SCHEMA public GRANT ALL ON SEQUENCES TO user;
- GRANT ALL PRIVILEGES ON ALL TABLES IN SCHEMA public TO user;
- GRANT ALL PRIVILEGES ON ALL SEQUENCES IN SCHEMA public TO user;
Add Comment
Please, Sign In to add comment