user restriction
Hi All,
I want to create a user in Postgres Database. And I want to restrict that user with some privileges. And also I want that user should be specific to particular database.
He should not be able to do the following
1) Connect to any other database.
2) Connect to System database (like Postgres).
He should only be able to connect to Specific Database & perform those activities which has been granted.
On Fri, Jun 01, 2007 at 11:15:30AM +0530, Ashish Karalkar wrote:
Hi All,
I want to create a user in Postgres Database. And I want to restrict
that user with some privileges. And also I want that user should be
specific to particular database.He should not be able to do the following
1) Connect to any other database.
2) Connect to System database (like Postgres).
Setup the pg_hba so that s/he can only connect to the database you
list. If it's applicable to you, you can also set it up so users can
only connect to the database with the same name as their username
(sameuser option).
Hope this helps,
--
Martijn van Oosterhout <kleptog@svana.org> http://svana.org/kleptog/
Show quoted text
From each according to his ability. To each according to his ability to litigate.