Re: GRANTing privileges to a plpgsql function doesn't

From: Doug McNaught <doug(at)mcnaught(dot)org>
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
Date: 2004-06-09 13:18:04
Message-ID: 87lliw6far.fsf@asmodeus.mcnaught.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

"Greg" <greg(dot)wickham(at)grangenet(dot)net> writes:

> Hi,
>
> 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.

Look at the WITH SECURITY DEFINER clause to CREATE FUNCTION (I think
that's where it is).

-Doug

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Scot L. Harris 2004-06-09 13:45:10 Re: Multiple databases on seperate drives/file systems?
Previous Message Shridhar Daithankar 2004-06-09 13:17:30 Re: Prevent users from creating tables