Skip site navigation (1) Skip section navigation (2)

Re: common_fields: permission denied

From: "Nick Fankhauser" <nickf(at)ontko(dot)com>
To: "Olivier Reuland" <olivier(dot)reuland(at)adm(dot)unige(dot)ch>,<pgsql-admin(at)postgresql(dot)org>
Subject: Re: common_fields: permission denied
Date: 2003-07-21 16:22:50
Message-ID: (view raw or whole thread)
Lists: pgsql-admin

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?


> -----Original Message-----
> From: pgsql-admin-owner(at)postgresql(dot)org
> [mailto:pgsql-admin-owner(at)postgresql(dot)org]On Behalf Of Olivier Reuland
> Sent: Monday, July 21, 2003 7:56 AM
> To: pgsql-admin(at)postgresql(dot)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   trust
> host    all         all    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?

In response to


pgsql-admin by date

Next:From: Jean-Michel ChabanneDate: 2003-07-21 19:32:55
Subject: Re: PG_dump fatal error (second post)
Previous:From: Olivier ReulandDate: 2003-07-21 13:26:28
Subject: common_fields: permission denied (more)

Privacy Policy | About PostgreSQL
Copyright © 1996-2015 The PostgreSQL Global Development Group