Re: security definer function - Mailing list pgsql-sql

From Peter Eisentraut
Subject Re: security definer function
Date
Msg-id Pine.LNX.4.44.0310142012040.22628-100000@peter.localdomain
Whole thread Raw
In response to security definer function  (Tomek <myrcioch@poczta.onet.BLABLA.pl>)
List pgsql-sql
Tomek writes:

> A) function defined with "SECURITY DEFINER"
> B) function defined with "SECURITY INVOKER"
>
> Function A calls function B.
>
> How is the function b called - with rights of definer of function A,

Yes.

An easy way to arrive at this answer would have been to print current_user
in function B.

-- 
Peter Eisentraut   peter_e@gmx.net



pgsql-sql by date:

Previous
From: Joe Conway
Date:
Subject: Re: Oracle 'connect by prior' now eaiser in 7.3?
Next
From: Rod Taylor
Date:
Subject: Re: [PERFORM] sql performance and cache