Re: BUG #5147: DBA can not access view

[donniehan <donniehan(at)126(dot)com>]

Hi Tom,
Thanks for you reply, but i don't quite get it.
 
"The view is owned by user1 and what the view can access is determined by user1's permissions"
 
Why? I don't get it. 
On one hand, if user1 can not access tb2, he should not be able to create the view based on tb2.
On the other hand, user1 does own view1, but view1 is an independent object in database. As a super user can access tb1 and tb2. Why he can not access view1 when user1 can't and when he can that 'cause user1 can.
I don't understand the design behavior.Can you explain me more detailedly?
Thanks! 




在2009-10-29?21:34:40，"Tom?Lane"?<tgl(at)sss(dot)pgh(dot)pa(dot)us>?写道：
>"Dongni"?<donniehan(at)126(dot)com>?writes:
>>?Description:????????DBA?can?not?access?view
>
>This?is?not?a?bug.??The?view?is?owned?by?user1?and?what?the?view?can
>access?is?determined?by?user1's?permissions,?independently?of?who?is
>calling?it.
>
>			regards,?tom?lane




看陆川杨幂新片《琴棋书画》，品网易3D国韵网游《天下贰》


看陆川杨幂新片《琴棋书画》，品网易3D国韵网游《天下贰》