Add User to Database
Assign a PostgreSQL database user to a database
From this page, you can assign privileges for a PgSQL database user to a particular database.
Location :
PostgreSQL -> Add User to Database
You can select the following to assign the user,
Select Database , a database to add
Select Database User, a PgsQL user to assign to the database
Both Database and User need to be in the same PgSQL server to assign.