Re: Preventing access of user1 to user2's database

Danjel Jungersen <danjel@jungersen.dk>

From: "Danjel Jungersen" <danjel@jungersen.dk>
To: pgsql-novice@postgresql.org
Date: 2006-01-10T14:02:05Z
Lists: pgsql-novice
On 10 Jan 2006 at 12:01, Joao Miguel Ferreira wrote:

> I must say that my pg_hba.conf contains 2 lines (one for 127.0.0.1 and
> another for 10.0.24.x) with the 'all' word for databases and
> tables.... could this be the reason ? Could this file override user
> priviliges ? ...This file is still confusing for me....
I think so...
By memory, there is an option "sameuser" (or something like it), that 
should do the trick.
I have to say that I have not yet managed to get my server running, 
so I may not be all correct ;-)

Best of luck
Danjel