PostgreSQL user management

psql_manage_users.sql

-- Add a user with readonly privileges to db
CREATE USER username WITH PASSWORD '<password>';
GRANT SELECT ON ALL TABLES IN SCHEMA public TO username;
GRANT SELECT ON ALL SEQUENCES IN SCHEMA public TO username;

-- Delete a user
revoke all privileges on all tables in schema public from username;
drop user username;

-- Add a "root" user to database
GRANT ALL PRIVILEGES ON DATABASE database_name TO root;
GRANT ALL PRIVILEGES ON ALL TABLES IN SCHEMA public TO root;
GRANT ALL PRIVILEGES ON ALL SEQUENCES IN SCHEMA public TO root;