User and Role

[gouse]

Hi All

I have 1 Admin role and 3 non admin roles (like user_1,user_2.. ..).
There are 10 Database (like 1,2,3....10) in my PostgreSQL sever.

I am admin and want to assign access (no objects creation, no objects modification ---> only view) rights to specific database among these non admin roles.

Eg.

Database 1,2 are only access by user 1 & 2
Database 3,4,5 are only access by user 2,3
Database 8,9 are only access by user 3

So,
How can I manage role to achieve this requirements.

Thank You,
Gouse.

[michaelb]

You may want to look at two areas.
One is the pg_hba file where you can limit users and roles to connecting to only specified databases.
The other area would be setting roles and privileges, look
here for details.