From: | Jeff Eckermann <jeff_eckermann(at)yahoo(dot)com> |
---|---|
To: | josh(at)agliodbs(dot)com, pgsql-sql(at)postgresql(dot)org |
Subject: | Re: Delete denied? |
Date: | 2003-08-23 16:55:44 |
Message-ID: | 20030823165544.84475.qmail@web20809.mail.yahoo.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-sql |
--- Josh Berkus <josh(at)agliodbs(dot)com> wrote:
> Stephan, Tom:
>
> Hey, I have a function which can involve some
> records being deleted at the
> end. The user calling the function has permission
> to delete records (and
> I've tested this), but when I run the function I get
> "permission denied".
>
I had a similar weird problem recently, also with
7.2.4. Whether the two problems are related I can't
tell, but...
Situation: user a updates table1 (owned by a), kicks
off a trigger which updates table2 (owned by user b).
Wouldn't work. I tried every ownership and permission
combination that I could think of without success,
before succeeding by doing a "grant all on table2 to
a".
Since the table access is all mediated through the
application I was not worried about the "all", but the
question remains: why would "grant all" permit
updates, when "grant update" would not?
> Any clue? I remember in 7.1.x that you couldn't
> delete records in a function,
> but this is on 7.2.4.
>
> Contributing could be that the table holding the
> deleted records is a child
> table with an "ON CASCADE DELETE" of one of the
> tables being updated
> elsewhere in the function. And the function works
> if called by the owner of
> the table (and the function).
>
> --
> -Josh Berkus
> Aglio Database Solutions
> San Francisco
>
>
> ---------------------------(end of
> broadcast)---------------------------
> TIP 6: Have you searched our list archives?
>
> http://archives.postgresql.org
__________________________________
Do you Yahoo!?
Yahoo! SiteBuilder - Free, easy-to-use web site design software
http://sitebuilder.yahoo.com
From | Date | Subject | |
---|---|---|---|
Next Message | Bertrand Petit | 2003-08-24 01:28:15 | Equality operators on NULL values |
Previous Message | Rajesh Kumar Mallah | 2003-08-23 09:30:37 | Re: Joined deletes but one table being a subquery. |