Postgres Pro
Downloads
Home   >   mailing lists

Re: GRANTing privileges to a plpgsql function doesn't give required result (pg 7.3.4) - Mailing list pgsql-general

From Tom Lane
Subject Re: GRANTing privileges to a plpgsql function doesn't give required result (pg 7.3.4)
Date
Msg-id 12339.1078025747@sss.pgh.pa.us
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:
> 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

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: pg_dump and pg_dumpall fail when trying to backup database
Next
From: Tom Lane
Date:
Subject: Re: pg_dumpall dies