Postgres Pro
Downloads
Home   >   mailing lists

Re: GRANTing privileges to a plpgsql function doesn't - Mailing list pgsql-general

From Doug McNaught
Subject Re: GRANTing privileges to a plpgsql function doesn't
Date
Msg-id 87lliw6far.fsf@asmodeus.mcnaught.org
Whole thread Raw
In response to GRANTing privileges to a plpgsql function doesn't give required result (pg 7.3.4)  ("Greg" <greg.wickham@grangenet.net>)
List pgsql-general
Tree view 
"Greg" <greg.wickham@grangenet.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

pgsql-general by date:

Previous
From: Shridhar Daithankar
Date:
Subject: Re: Prevent users from creating tables
Next
From: "Scot L. Harris"
Date:
Subject: Re: Multiple databases on seperate drives/file systems?