Skip site navigation (1) Skip section navigation (2)

Re: DML Restriction unless through a function

From: Bruno Wolff III <bruno(at)wolff(dot)to>
To: Adam Witney <awitney(at)sghms(dot)ac(dot)uk>
Cc: val(at)webtribe(dot)net, pgsql-general <pgsql-general(at)postgresql(dot)org>
Subject: Re: DML Restriction unless through a function
Date: 2004-06-30 14:35:41
Message-ID: 20040630143541.GA14493@wolff.to (view raw or flat)
Thread:
Lists: pgsql-general
On Wed, Jun 30, 2004 at 15:02:33 +0100,
  Adam Witney <awitney(at)sghms(dot)ac(dot)uk> wrote:
> 
> Out of interest, what are the issues?

You should be able to find a more accurate description in the archives, but
my memory is that when you run a security definer function in a view
(this shouldn't apply if it is used as a default for a column in the view) it
runs with the authority of the view creator ran than the function creator.
In practice that probably isn't a problem, since normally they would be
the same person.

In response to

Responses

pgsql-general by date

Next:From: Andy BDate: 2004-06-30 14:44:18
Subject: Enough RAM for entire Database.. cost aside, is this going to be fastest?
Previous:From: Tom LaneDate: 2004-06-30 14:32:56
Subject: Re: minimum operators for b-tree, r-tree

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group