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

RE : common_fields: permission denied

From: Olivier Reuland <olivier(dot)reuland(at)adm(dot)unige(dot)ch>
To: nickf(at)ontko(dot)com
Cc: pgsql-admin(at)postgresql(dot)org
Subject: RE : common_fields: permission denied
Date: 2003-07-22 11:28:24
Message-ID: 000801c35044$5d522a90$6310c281@Swip (view raw or flat)
Thread:
Lists: pgsql-admin
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(at)postgresql(dot)org 
> [mailto:pgsql-admin-owner(at)postgresql(dot)org] De la part de Nick 
> Fankhauser
> Envoyé : lundi, 21. juillet 2003 18:23
> À : Olivier Reuland; pgsql-admin(at)postgresql(dot)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(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         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
> 


In response to

Responses

pgsql-admin by date

Next:From: Mendola GaetanoDate: 2003-07-22 17:10:14
Subject: Wrong plan or what ?
Previous:From: Renney ThomasDate: 2003-07-22 08:04:46
Subject: Re: Documentation of Concepts

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