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

From Tom Lane
Subject Re: BUG #3265: 8.1 -> 8.2 behviour change: View owner must have access to underlying tables
Date
Msg-id 12588.1178804622@sss.pgh.pa.us
Whole thread Raw
In response to Re: BUG #3265: 8.1 -> 8.2 behviour change: View owner must have access to underlying tables  (Russell Smith <mr-russ@pws.com.au>)
List pgsql-bugs
Russell Smith <mr-russ@pws.com.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

pgsql-bugs by date:

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