Re: [COMMITTERS] pgsql: Automatic view update rules Bernd Helmle

Peter Eisentraut <peter_e@gmx.net> writes:
> On Saturday 24 January 2009 02:17:13 Tom Lane wrote:
>> 2. You don't want those rules, so you delete them, leaving you with the
>> traditional behavior where attempted inserts etc on the view fail.

> This was never meant to be supported.  If you don't want updates on the rules
> to succeed, don't grant privileges.

If we'd had the SQL-spec behavior from day one, it wouldn't be a
problem, but you can't just blow off the old behavior like that.
It's a potential security hole, since GRANT ALL on a view used to
be de facto the same as GRANT SELECT, if you hadn't bothered to
create any rules.
        regards, tom lane