Re: [BUGS] BUG #5147: DBA can not access view

2009-11-02 Thread donniehan
Hi Robert, Okay i get what you mean, you can finish this thread. Thanks for reply anyway! Regards -Dongni 在2009-11-02?22:56:03,"Robert?Haas"??写道: >2009/11/2?donniehan?: >>?Hi?Tom, >> >>?I?agree?with?Hxli.?It?may?be?a?good?way?to?add?permissions?check?when?create

Re: [BUGS] BUG #5147: DBA can not access view

2009-11-01 Thread donniehan
Hi Tom, I agree with Hxli. It may be a good way to add permissions check when create the view. I also find 2 pieces of words in the document about the owner of the object. "By default, only the owner of an object can do anything with the object." "as the owner has all privileges by default

Re: [BUGS] BUG #5147: DBA can not access view

2009-10-30 Thread donniehan
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, user