Postgres Pro
Downloads
Home   >   mailing lists

Re: User right management concerning functions - Mailing list pgsql-novice

From Bruno Wolff III
Subject Re: User right management concerning functions
Date
Msg-id 20050304144333.GA17492@wolff.to
Whole thread Raw
In response to User right management concerning functions  ("Christian Hofmann" <christian.hofmann@gmx.de>)
List pgsql-novice
Tree view 
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.

pgsql-novice by date:

Previous
From: "Pradeepkumar, Pyatalo (IE10)"
Date:
Subject: Help on Trigger functions
Next
From: Bruno Wolff III
Date:
Subject: Re: Import csv file into multiple tables in Postgres