Olivier-
The pg_hba.conf file controls how users connect to the database, but if the
user does not have grants on the specific table within the database, I think
you'd be getting an error similar to the one you describe. Does the user you
created either have "dba" privileges or select access on the table?
-Nick
> -----Original Message-----
> From: pgsql-admin-owner@postgresql.org
> [mailto:pgsql-admin-owner@postgresql.org]On Behalf Of Olivier Reuland
> Sent: Monday, July 21, 2003 7:56 AM
> To: pgsql-admin@postgresql.org
> Subject: [ADMIN] common_fields: permission denied
>
>
> 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 trust
> host all all 127.0.0.1 255.255.255.255 trust
> host all all 0.0.0.0 255.255.255.255 reject
>
> When I try to run "./pg_dump --username=user1 --password db1" I have an
> error saying :
>
> pg_dump: Attempt to lock table "common_fields" failed. ERROR:
> common_fields: permission denied
>
>
> Any idea ?
>
> Thanks
>
> Oliver
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 5: Have you checked our extensive FAQ?
>
> http://www.postgresql.org/docs/faqs/FAQ.html
>