Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: user "PUBLIC" not in All_USERS

Re: user "PUBLIC" not in All_USERS

From: Daniel Morgan <damorgan_at_x.washington.edu>
Date: Sun, 18 Jul 2004 16:24:06 -0700
Message-ID: <1090193067.848455@yasure>


Michel Cadot wrote:

> "Daniel Morgan" <damorgan_at_x.washington.edu> a écrit dans le message de
> news:1090179381.633491_at_yasure...
> 

>>Michel Cadot wrote:
>>
>>>"Praveen" <nospam_at_nospam.com> a écrit dans le message de
>>>news:cd7150$gfa$1_at_news1brm.Central.Sun.COM...
>>>
>>>
>>>>Hi..All,
>>>>
>>>> I have a quick question. Why am I not able to see the user "PUBLIC"
>>>>in ALL_USERS table.
>>>>
>>>>Regards,
>>>>
>>>>P
>>>>
>>>
>>>
>>>PUBLIC is neither a user nor a role, it's a user group.
>>>It has been defined as it in Oracle version 6.
>>>It's the only user group but version 6 doc seemed to
>>>understand that someday there will be other groups
>>>(something like all users belong to a group, PUBLIC by default).
>>>Then roles come in version 7 and user group idea disappeared,
>>>just PUBLIC rested.
>>>From which all the inconsistencies Pete showed trying to fit
>>>PUBLIC in a role role.
>>>
>>>--
>>>Regards
>>>Michel Cadot
>>
>>Thanks. This post didn't show up here until today.
>>
>>This reminds me very much as being similar to the fact that everyone is
>>a member of the DEFAULT profile and works in the LIVE workspace.
>>
>>Daniel Morgan
>>
> 
> 
> ...and belongs to DEFAULT_CONSUMER_GROUP resource consumer group.
> 
> --
> Regards
> Michel Cadot

Seems like it could be about time for a consolidation before they create even more of these.

Daniel Morgan Received on Sun Jul 18 2004 - 18:24:06 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US