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"?<robertmh...@gmail.com>?写道: >2009/11/2?donniehan?<donnie...@126.com>: >>?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." >> >>?In?my?case,?as?the?view1?is?already?owned?by?user1,?so?user1?should?has?all >>?privileges?of?view1,?but?user1?can?not?select?from?view1,?I?am?very?confused >>?by?these?words.?So?it?maybe?necessary?to?check?the?user's?permissions?when >>?he?create?the?object. > >Guys,?this?is?pretty?straightforward.??The?permissions?on?the?view >determine?who?can?access?it.??The?permissions?of?the?view?owner >determine?what?the?view?can?access.??The?way?to?think?about?this?may >be?that?a?view?acts?a?bit?like?a?setuid?program?under?UNIX:?a?regular >user?can?gain?superuser?privileges;?a?superuser?can?give?them?up. > >This?may?or?may?not?make?sense?to?you?and?it?may?or?may?not?be?what >you?want,?but?it's?NOT?A?BUG.??It's?done?that?way?on?purpose,?it's >well-documented,?and?it's?been?that?way?for?a?long?time.??If?you?want >some?explanation?of?WHY?is?that?way?and?what?it?might?be?useful?for, >start?by?reading?the?documentation?and?then?if?you?have?questions,?ask >on?the?appropriate?mailing?list,?maybe?pgsql-general?or?pgsql-novice. > >...Robert