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: [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, > > 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 > ---------------------------(end of broadcast)--------------------------- TIP 7: don't forget to increase your free space map settings
