postgres give user full access to database code example
Example: how to give access to database in postgresql server to another user
GRANT permissions ON DATABASE dbname TO username;
GRANT permissions ON DATABASE dbname TO username;