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

setuid for defaults, constraints and triggers (Was: What user to [sic] defaults execute as?)

From: Bruno Wolff III <bruno(at)wolff(dot)to>
To: pgsql-hackers(at)postgresql(dot)org
Subject: setuid for defaults, constraints and triggers (Was: What user to [sic] defaults execute as?)
Date: 2002-10-31 14:54:02
Message-ID: 20021031145402.GA12641@wolff.to (view raw or flat)
Thread:
Lists: pgsql-generalpgsql-hackers
Constraints also run as the user modifying a table instead of the table
owner.
Again I don't see a good reason to want to execute constraints as the
user modifying a table. But I do think there can be reasons to want to
execute them as the table owner.

To summarize, my suggestion for change is:

Execute default expressions and constraints as the owner of the table.
Execute triggers as the owner of the trigger.

In response to

Responses

pgsql-hackers by date

Next:From: Rod TaylorDate: 2002-10-31 15:17:26
Subject: Re: setuid for defaults, constraints and triggers (Was:
Previous:From: Pedro M. FerreiraDate: 2002-10-31 14:48:53
Subject: Re: float output precision questions

pgsql-general by date

Next:From: Ericson SmithDate: 2002-10-31 15:04:40
Subject: Re: handling 20,000 connection?
Previous:From: Reid ThompsonDate: 2002-10-31 14:45:10
Subject: Could someone post a full example of using SQL & bytea to store/retrieve image data

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