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 <[EMAIL PROTECTED]> http://svana.org/kleptog/ > From each according to his ability. To each according to his ability to > litigate.
signature.asc
Description: Digital signature
