Re: change owner strange behavior

8.1.11

On Mon, Aug 9, 2010 at 9:29 PM, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:
> David Galkowski <david(dot)galkowski(at)gmail(dot)com> writes:
>> In order to consolidate two users, user1 and user2, in the database I
>> changed the owner of all tables and views that user2 owned to be owned
>> by user1.  I then revoked all remaining privileges from user2 and
>> dropped the role.  During this process I changed both table1 and view1
>> (that selects from table1) to be owned by user1.  After this process,
>> user1 cannot select from view1 with an error saying permission denied
>> on table1.
>
> Works for me ... what PG version are you dealing with?
>
>                        regards, tom lane
>