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

From: Bruno Wolff III <bruno(at)wolff(dot)to>
To: Rod Taylor <rbt(at)rbt(dot)ca>
Cc: PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: setuid for defaults, constraints and triggers (Was: What user to [sic] defaults execute as?)
Date: 2002-10-31 15:33:59
Message-ID: 20021031153359.GA13245@wolff.to
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general pgsql-hackers

On Thu, Oct 31, 2002 at 10:17:26 -0500,
Rod Taylor <rbt(at)rbt(dot)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.

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message scott.marlowe 2002-10-31 16:06:04 Re: DAFS?
Previous Message Rod Taylor 2002-10-31 15:17:26 Re: setuid for defaults, constraints and triggers (Was:

Browse pgsql-hackers by date

  From Date Subject
Next Message Robert E. Bruccoleri 2002-10-31 15:35:11 Test of PG7.3.2b2 on SGI Irix
Previous Message Rod Taylor 2002-10-31 15:17:26 Re: setuid for defaults, constraints and triggers (Was: