Re: Views permessions

salah jubeh <s_jubeh@yahoo.com> writes:
> There is a problem confusing me. I have two views 'VIEW1' and 'VIEW2'

> 1. VIEW2 depends on VIEW1
> 2. VIEW2 and VIEW1 have the exact permissions
> 3. I can execute  SELECT * from VIEW1 ; without problem
> 4. When I execute  SELECT * from VIEW2; I get
> ERROR:  permission denied for relation VIEW1
> 5. The owner of the views is not me, But I am a super user

VIEW2's reference to VIEW1 is checked according to the permissions
granted to the owner of VIEW2.  Whether the ultimate caller is a
superuser doesn't affect this.

            regards, tom lane