On Tue, Jul 22, 2003 at 13:28:24 +0200,
Olivier Reuland <[EMAIL PROTECTED]> wrote:
> Hi Nick,
>
> I have done a "GRANT ALL PRIVILEGES ON DATABASE db1 TO user1". The message I
> had back was "GRANT". But this was not enough, I had to give access to all
> tables...
The above granted user1 the abi
]
> [mailto:[EMAIL PROTECTED] De la part de Nick
> Fankhauser
> Envoyé : lundi, 21. juillet 2003 18:23
> À : Olivier Reuland; [EMAIL PROTECTED]
> Objet : Re: [ADMIN] common_fields: permission denied
>
>
> Olivier-
>
> The pg_hba.conf file controls how users conne
Just to add more info I made a "pg_dumpall | grep user1" to be sure that the
user was really created, which sounds to be the case :
CREATE USER user1 WITH SYSID 100 NOCREATEDB NOCREATEUSER;
> Hi there,
>
> I have a problem accessing my postgres database when using a
> specific user...
>
> If
elect access on the table?
-Nick
> -Original Message-
> From: [EMAIL PROTECTED]
> [mailto:[EMAIL PROTECTED] Behalf Of Olivier Reuland
> Sent: Monday, July 21, 2003 7:56 AM
> To: [EMAIL PROTECTED]
> Subject: [ADMIN] common_fields: permission denied
>
>
> Hi there,
Hi there,
I have a problem accessing my postgres database when using a specific
user...
If I run and pg_dumpall using the postgres linux user I have no problem.
Then I tried to add a new user only for one database (let say "user1" and
"db1"). My pg_hba.conf looks like :
local all all
