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
>
