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

Re: Permission denied while insert

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Jose Manuel Lorenzo Lopez <jose-manuel(dot)lorenzo-lopez(at)conti(dot)de>
Cc: PostgreSQL General List <pgsql-general(at)postgresql(dot)org>
Subject: Re: Permission denied while insert
Date: 2001-02-27 19:00:20
Message-ID: 5006.983300420@sss.pgh.pa.us (view raw or flat)
Thread:
Lists: pgsql-general
Jose Manuel Lorenzo Lopez <jose-manuel(dot)lorenzo-lopez(at)conti(dot)de> writes:
> I created a table bdf_users as admin user 'postgres' and granted insert 
> access for this table to public.
> Now I want to insert a line as user 'jose' (That's me!) and got the
> following message: 
> ERROR:  bdf_users: Permission denied.

Hmm ... what does "\z bdf_users" (in psql) show?

> Am I doing anything dumb? I am using postgresql 7.0.3 on SuSE Linux 7.1
> (although I compiled by myself postgresql)

There is a bug in 7.0.* that causes the default owner's permissions to
be forgotten when you do an explicit GRANT; you then have to re-grant
ALL to yourself to reactivate the permissions you have by default.  But
that doesn't seem to apply to this case, since jose is not the owner of
bdf_users if I understood you correctly.

			regards, tom lane

In response to

Responses

pgsql-general by date

Next:From: Brent R. MatzelleDate: 2001-02-27 19:05:54
Subject: Re: vacuum and backup
Previous:From: Mitch VincentDate: 2001-02-27 18:52:30
Subject: Re: vacuum and backup

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