How to setup a new user and give that user permission over a database? I found this a hard question to answer, so I'm writing down my soltuion.
This worked for me on Postresql 15.
You need a superuser account, to create the database.
create database <database name>;
create user <user name> with encrypted password '<password>';
alter database <database name> owner to <user name>;
At that point, the user you created can login and create/edit/delete tables as you would expect within that one database.
Top comments (0)