Re: security definer function

From: Peter Eisentraut <peter_e(at)gmx(dot)net>
To: Tomek <myrcioch(at)poczta(dot)onet(dot)BLABLA(dot)pl>
Cc: Lista dyskusyjna pgsql-sql <pgsql-sql(at)postgresql(dot)org>
Subject: Re: security definer function
Date: 2003-10-14 18:13:11
Message-ID: Pine.LNX.4.44.0310142012040.22628-100000@peter.localdomain
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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(at)gmx(dot)net

In response to

Browse pgsql-sql by date

  From Date Subject
Next Message Rod Taylor 2003-10-14 18:15:39 Re: sql performance and cache
Previous Message Michael Brusser 2003-10-14 18:05:53 How to determine the current user