Re: BUG #6076: Unexpected "Security Definer / invoker" interaction - Mailing list pgsql-bugs

From Tom Lane
Subject Re: BUG #6076: Unexpected "Security Definer / invoker" interaction
Date
Msg-id 26125.1308929142@sss.pgh.pa.us
Whole thread Raw
In response to BUG #6076: Unexpected "Security Definer / invoker" interaction  ("Dave Fennell" <dave@microtux.co.uk>)
List pgsql-bugs
"Dave Fennell" <dave@microtux.co.uk> writes:
> I would expect that if a function defined as "security definer" calls a
> function defined as "security invoker" the "invoker" role used would be the
> "definer" of the first function?

So would I.

> However it appears that the *actual*
> invoker (current user) is used.

You did not provide any evidence of that.  Please show a *complete*
self-contained test case.

            regards, tom lane

pgsql-bugs by date:

Previous
From: "Dave Fennell"
Date:
Subject: BUG #6076: Unexpected "Security Definer / invoker" interaction
Next
From: Антон Степаненко
Date:
Subject: Re: could not read block XXXXX in file "base/YYYYY/ZZZZZZ": read only 160 of 8192 bytes