Lists: | pgsql-general |
---|
From: | Nico Latzer <nico(dot)latzer(at)r-kom(dot)de> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | owner cant delete from table, permission denied |
Date: | 2003-07-25 07:50:11 |
Message-ID: | 20030725095011.A13864@nl1.r-kom.de |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Lists: | pgsql-general |
if i try to delete a row from table "customer", it is not permitted
with msg "customer_discount: permission denied", which has foreign key to customer set ON DELETE NO ACTION
- even as the owner of the tables/database owner
- even when all triggers and rules removed on customer_discount
but i am able to delete a row from customer_discount with the same priviliges kept unchanged,
EXPLAIN DELETE FROM customer works,
EXPLAIN ANALYZE DELETE FROM customer fires "customer_discount: permission denied" again
Please can You give me any hint, in which
direction to look for.
IMO, pg_depend (old dependencies) couldnt be the reason, because theres no DROP involved
REINDEX customer* already done without problems, same with VACUUm
postgresql-7.3.2 , data was slurped in from 7.2 few months ago
Thanks for Your efforts,
-- Nico
From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
---|---|
To: | Nico Latzer <nico(dot)latzer(at)r-kom(dot)de> |
Cc: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: owner cant delete from table, permission denied |
Date: | 2003-08-01 00:50:50 |
Message-ID: | 2375.1059699050@sss.pgh.pa.us |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Lists: | pgsql-general |
Nico Latzer <nico(dot)latzer(at)r-kom(dot)de> writes:
> if i try to delete a row from table "customer", it is not permitted
Perhaps you revoked the owner's delete permission. See the GRANT and
REVOKE reference pages.
regards, tom lane
From: | Nico Latzer <nl(at)nl1(dot)r-kom(dot)de> |
---|---|
To: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
Cc: | <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: owner cant delete from table, permission denied |
Date: | 2003-08-01 07:47:50 |
Message-ID: | Pine.LNX.4.30.0308010934220.29114-100000@nl1.r-kom.de |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Lists: | pgsql-general |
On Thu, 31 Jul 2003, Tom Lane wrote:
> Nico Latzer <nico(dot)latzer(at)r-kom(dot)de> writes:
> > if i try to delete a row from table "customer", it is not permitted
>
> Perhaps you revoked the owner's delete permission. See the GRANT and
> REVOKE reference pages.
by setting "references customer on delete set null" the
^^^^^^^^^^
operation succeeded. - previously no "on action" part was defined
priveleges were set sth like
\z customer public=, group inhouse=arw, db_and_table_owner=ALL
\z customer_xxx public=, group inhouse=arw, db_and_table_owner=ALL
Thank You
-- Nico