By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,961 Members | 1,320 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,961 IT Pros & Developers. It's quick & easy.

User and Role

P: 18
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.
Jun 9 '07 #1
Share this Question
Share on Google+
1 Reply


Expert 100+
P: 534
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.
Jun 10 '07 #2

Post your reply

Sign in to post your reply or Sign up for a free account.