Re: setuid for defaults, constraints and triggers (Was: What user to [sic] defaults execute as?) - Mailing list pgsql-hackers

From Bruno Wolff III
Subject Re: setuid for defaults, constraints and triggers (Was: What user to [sic] defaults execute as?)
Date
Msg-id 20021031153359.GA13245@wolff.to
Whole thread Raw
In response to Re: setuid for defaults, constraints and triggers (Was:  (Rod Taylor <rbt@rbt.ca>)
Responses Re: setuid for defaults, constraints and triggers (Was:
List pgsql-hackers
On Thu, Oct 31, 2002 at 10:17:26 -0500, Rod Taylor <rbt@rbt.ca> wrote:
> Can't necessarily run them as the table owner, as it may give
> information to other users with the ability to ALTER that table.

You have to be the table owner to alter a table. So it should be OK
to have the default expressions and check constraints run as the owner.


pgsql-hackers by date:

Previous
From: Rod Taylor
Date:
Subject: Re: setuid for defaults, constraints and triggers (Was:
Next
From: "Robert E. Bruccoleri"
Date:
Subject: Test of PG7.3.2b2 on SGI Irix