Re: BUG #3265: 8.1 -> 8.2 behviour change: View owner must have access to underlying tables

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Russell Smith <mr-russ(at)pws(dot)com(dot)au>
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: BUG #3265: 8.1 -> 8.2 behviour change: View owner must have access to underlying tables
Date: 2007-05-10 13:43:42
Message-ID: 12588.1178804622@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

Russell Smith <mr-russ(at)pws(dot)com(dot)au> writes:
> But this also means that a super user is not really a super user
> anymore. Are we comfortable with this redefinition?

Hm? It has never been the case that a view would act differently for a
superuser than it would when invoked by someone else. The bug here is
in ALTER OWNER failing to reassign the view's permissions checks
properly, not in how they are enforced later.

regards, tom lane

In response to

Browse pgsql-bugs by date

  From Date Subject
Next Message John R Pierce 2007-05-10 15:39:37 INSTALL appnote for Solaris 10...
Previous Message Russell Smith 2007-05-10 08:41:08 Re: BUG #3265: 8.1 -> 8.2 behviour change: View owner must have access to underlying tables