nem.ec

Programming Information Security Recipes Personal Code Snippets

User management in Postgres databases

Some description

Create a user

CREATE USER iguser WITH ENCRYPTED PASSWORD 'abcde';

Grant privileges to user

GRANT ALL PRIVILEGES ON DATABASE instagram TO iguser;
GRANT ALL PRIVILEGES ON ALL TABLES IN SCHEMA public TO iguser;