Re: User right management concerning functions

From: Bruno Wolff III <bruno(at)wolff(dot)to>
To: Christian Hofmann <christian(dot)hofmann(at)gmx(dot)de>
Cc: pgsql-novice(at)postgresql(dot)org
Subject: Re: User right management concerning functions
Date: 2005-03-04 14:43:33
Message-ID: 20050304144333.GA17492@wolff.to
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

On Wed, Mar 02, 2005 at 19:44:41 +0100,
Christian Hofmann <christian(dot)hofmann(at)gmx(dot)de> wrote:
> Hello,
>
> is it possible to create a postgresql-user without the right to use the SQL
> INSERT command but with the right to call a function that is using some SQL
> INSERT commands?
>
> Is this also possible with the SQL DELETE command?

Yes. You can use the SECURITY DEFINER property of functions to do this.

In response to

Browse pgsql-novice by date

  From Date Subject
Next Message Keith Worthington 2005-03-04 15:00:27 Re: Help on Trigger functions
Previous Message Stuart Bishop 2005-03-04 12:49:11 Re: PL/Pgsql or PL/Python?