8.1.11
On Mon, Aug 9, 2010 at 9:29 PM, Tom Lane <tgl@sss.pgh.pa.us> wrote:
> David Galkowski <david.galkowski@gmail.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
>