Re: adding a db-specific user

From: Bruno Wolff III <bruno(at)wolff(dot)to>
To: Sally Sally <dedeb17(at)hotmail(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: adding a db-specific user
Date: 2004-07-09 17:27:42
Message-ID: 20040709172742.GA22351@wolff.to
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Fri, Jul 09, 2004 at 17:06:20 +0000,
Sally Sally <dedeb17(at)hotmail(dot)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.

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Ian Harding 2004-07-09 17:42:52 Re: Training and certification
Previous Message Markus Bertheau 2004-07-09 17:16:14 order of statements in create function