Обсуждение: User right management concerning functions

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?

Thank you for every hint,

Christian

On Wed, Mar 02, 2005 at 19:44:41 +0100,
  Christian Hofmann <christian.hofmann@gmx.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.