Re: Private functions - Mailing list pgsql-sql

From silly sad
Subject Re: Private functions
Date
Msg-id 4B9DD2D1.1050004@bankir.ru
Whole thread Raw
In response to Re: Private functions  (Jasen Betts <jasen@xnet.co.nz>)
List pgsql-sql
On 03/14/10 06:21, Jasen Betts wrote:
> On 2010-03-13, Gianvito Pio<pio.gianvito@gmail.com>  wrote:
>> Hi all,
>> is there a way to write a function that can only be called by another
>> function but not directly using SELECT function_name ( )?
>
> not really.
>
> but there may be another way to get the effect you want.
>

read the section SECURITY DEFINER
and GRANT and REVOKE and CREATE USER


pgsql-sql by date:

Previous
From: Mark Lubratt
Date:
Subject: Linked list with CTE
Next
From: silly sad
Date:
Subject: Re: Odd query behavior