Re: Private functions

From: silly sad <sad(at)bankir(dot)ru>
To: pgsql-sql(at)postgresql(dot)org
Subject: Re: Private functions
Date: 2010-03-15 06:25:21
Message-ID: 4B9DD2D1.1050004@bankir.ru
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

On 03/14/10 06:21, Jasen Betts wrote:
> On 2010-03-13, Gianvito Pio<pio(dot)gianvito(at)gmail(dot)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

In response to

Browse pgsql-sql by date

  From Date Subject
Next Message silly sad 2010-03-15 11:27:17 Re: Odd query behavior
Previous Message Mark Lubratt 2010-03-14 23:51:53 Linked list with CTE