template1=# CREATE USER username WITH PASSWORD 'user_password'; template1=# GRANT ALL PRIVILEGES ON DATABASE "user_database" to username;