Thread: Permission denied while insert
Hi folks, I noticed a strange behavior of my DB. Let me explain: 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. Am I doing anything dumb? I am using postgresql 7.0.3 on SuSE Linux 7.1 (although I compiled by myself postgresql) Best Regards José Manuel Lorenzo López -- ********************************************************************** ** José Manuel Lorenzo López ** ** ** ** ICA Informationssysteme Consulting & Anwendungsgesellschaft mbH ** ** Dept. SAP Basis R/3 VBue ** ** ** ** e-mail to: jose-manuel.lorenzo-lopez@conti.de ** **********************************************************************
Tulio Oliveira schrieb: > are you inserting directly over the table, or in a view of this table ? > > I had problems inserting data in a View with no records ... Hello Tulio, nope, I am inserting directly into the table! The table is also filled with some data. Best Regards / Un saludo / Mit freundlichen Grüßen / Cordiali Saluti José Manuel Lorenzo López -- ********************************************************************** ** José Manuel Lorenzo López ** ** ** ** ICA Informationssysteme Consulting & Anwendungsgesellschaft mbH ** ** Dept. SAP Basis R/3 VBue ** ** ** ** e-mail to: jose-manuel.lorenzo-lopez@conti.de ** **********************************************************************
Jose Manuel Lorenzo Lopez wrote: > Hi folks, > > I noticed a strange behavior of my DB. Let me explain: > > 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. > > Am I doing anything dumb? I am using postgresql 7.0.3 on SuSE Linux 7.1 > (although I compiled by myself postgresql) > > Best Regards > > José Manuel Lorenzo López > are you inserting directly over the table, or in a view of this table ? I had problems inserting data in a View with no records ... regards Tulio
Jose Manuel Lorenzo Lopez <jose-manuel.lorenzo-lopez@conti.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
Hello Tom,
Tom Lane wrote:
> Jose Manuel Lorenzo Lopez <jose-manuel.lorenzo-lopez@conti.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?
\z bdf_users
Access permissions for database "jose"
Relation | Access permissions
-------------------------------
bdf_users | {"=ar"}
This seems to be okay!
> 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.
Yes, the table was created by the admin user 'postgres' and this user
is able to insert, update, ... The only thing that user 'jose' is able
to is doing select on the table bdf_users. Thank you otherwise for the
advice
about the bug in 7.0.* :)
Best regards,
José Manuel Lorenzo López
--
**********************************************************************
** José Manuel Lorenzo López **
** **
** ICA Informationssysteme Consulting & Anwendungsgesellschaft mbH **
** Dept. SAP Basis R/3 VBue **
** **
** e-mail to: jose-manuel.lorenzo-lopez@conti.de **
**********************************************************************