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.