Postgres Create Users

postgres-create-user.md

Postgres Users

Create User

CREATE USER mynewuser PASSWORD 'mynewpassword';

Drop User

DROP USER mynewuser;

Alter Role Super User

• SUPERUSER/NOSUPERUSER
• CREATEDB/NOCREATEDB
• CREATEROLE/NOCREATEROLE
• CREATEUSER/NOCREATEUSER
• LOGIN/NOLOGIN
• PASSWORD
• VALID UNTIL

ALTER ROLE <rol name> WITH <options>;
-- Example
ALTER ROLE mynewuser WITH SUPERUSER;

Change Password

ALTER ROLE mynewuser WITH PASSWORD 'mynewpassword';

Create Database

CREATE DATABASE mydatabase WITH OWNER mynewuser;

Grant Privileges

GRANT ALL PRIVILEGES ON DATABASE mydatabase TO mynewuser;