| 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: | Whole Thread | Raw Message | 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.
| 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 |