Re: adding a db-specific user - Mailing list pgsql-general

From Bruno Wolff III
Subject Re: adding a db-specific user
Date
Msg-id 20040709172742.GA22351@wolff.to
Whole thread Raw
In response to adding a db-specific user  ("Sally Sally" <dedeb17@hotmail.com>)
List pgsql-general
On Fri, Jul 09, 2004 at 17:06:20 +0000,
  Sally Sally <dedeb17@hotmail.com> wrote:
> I was wandering how I can add a user to a specific db. There are several
> databases but I want to add the user to only one of them. It seems when I
> add a new user, it is entered in the pg_user table and I can log in to any
> one of the other dbs (ofcourse I won't be able to do anything until I grant
> permission still I don't even want to be able to log in to the other dbs
> and see the db schema etc).
> Does anybody know how to avoid this?

You can control this in pg_hba.conf.

pgsql-general by date:

Previous
From: Markus Bertheau
Date:
Subject: order of statements in create function
Next
From: "Ian Harding"
Date:
Subject: Re: Training and certification