Thread: 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
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 >
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... It's working now, thanks. Oliver > -----Message d'origine----- > De : pgsql-admin-owner@postgresql.org > [mailto:pgsql-admin-owner@postgresql.org] De la part de Nick > Fankhauser > Envoyé : lundi, 21. juillet 2003 18:23 > À : Olivier Reuland; pgsql-admin@postgresql.org > Objet : Re: [ADMIN] common_fields: permission denied > > > 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 > > > > > ---------------------------(end of > broadcast)--------------------------- > TIP 7: don't forget to increase your free space map settings >
On Tue, Jul 22, 2003 at 13:28:24 +0200, Olivier Reuland <olivier.reuland@adm.unige.ch> 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 ability to create schemas and temporary tables in the database.