Re: GRANTing privileges to a plpgsql function doesn't give required result (pg 7.3.4)

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Greg" <greg(dot)wickham(at)grangenet(dot)net>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: GRANTing privileges to a plpgsql function doesn't give required result (pg 7.3.4)
Date: 2004-02-29 03:35:47
Message-ID: 12339.1078025747@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

"Greg" <greg(dot)wickham(at)grangenet(dot)net> writes:
> When GRANTing execute to a plpgsql function it
> appears to run with the priviledge of the user and
> NOT with the priviledges of the owner of the function.

That's what it's supposed to do. See the SECURITY DEFINER
option of CREATE FUNCTION for the other behavior.

regards, tom lane

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2004-02-29 03:42:09 Re: pg_dumpall dies
Previous Message Tom Lane 2004-02-29 03:34:14 Re: pg_dump and pg_dumpall fail when trying to backup database