Skip site navigation (1) Skip section navigation (2)

Re: BUG #5147: DBA can not access view

From: donniehan <donniehan(at)126(dot)com>
To: "Robert Haas" <robertmhaas(at)gmail(dot)com>
Cc: pgsql-bugs <pgsql-bugs(at)postgresql(dot)org>
Subject: Re: BUG #5147: DBA can not access view
Date: 2009-11-02 15:19:35
Message-ID: 25247889.858821257175175816.JavaMail.coremail@bj126app89.126.com (view raw or flat)
Thread:
Lists: pgsql-bugs
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"?<robertmhaas(at)gmail(dot)com>?写道:
>2009/11/2?donniehan?<donniehan(at)126(dot)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

In response to

pgsql-bugs by date

Next:From: Sergey KonoplevDate: 2009-11-02 16:42:24
Subject: BUG #5159: 8.4.1 Segmentation fault
Previous:From: Robert HaasDate: 2009-11-02 14:56:03
Subject: Re: BUG #5147: DBA can not access view

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group