Re: BUG #1142: Problem with update permissions for view

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Arturs Zoldners <az(at)rpiva(dot)lv>
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: BUG #1142: Problem with update permissions for view
Date: 2004-04-30 16:48:19
Message-ID: 26510.1083343699@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

Arturs Zoldners <az(at)rpiva(dot)lv> writes:
> -- The following rule prevents user x to update public_data:
> CREATE RULE log_public AS ON UPDATE TO private_data WHERE (new.a <>
> old.a) DO INSERT INTO private_log (old_val, new_val) VALUES (old.a,
> new.a);

This is a known problem. It's fixed for 7.5 but there seems no way to
back-port the fix into existing release series (without forcing initdb).

The error is essentially that the use of an INSERT command as the rule
body causes the original view to be checked for INSERT rather than
UPDATE permissions ...

regards, tom lane

In response to

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Tom Lane 2004-04-30 16:52:05 Re: [BUGS] BUG #1134: ALTER USER ... RENAME breaks md5 passwords
Previous Message PostgreSQL Bugs List 2004-04-30 15:43:17 BUG #1145: silent REVOKE failures