Re: User PUBLIC questions

I will take your advice and look around catalog.sql .

 I thought PUBLIC was a user because the book says it is a user and also when using OEM, PUBLIC shows up as a user right along with all the other users in the user folder.

Thanks,
Mike

"Anurag Varma" <avdbi_at_hotmail.com> wrote in message news:n5gyb.10196$a54.3362_at_nwrddc03.gnilink.net...
>
> "Michael J. Moore" <NOhicamelSPAM_at_comcast.net> wrote in message
> news:dOdyb.358587$HS4.3001555_at_attbi_s01...
> > 1)Why does user PUBLIC not show up in DBA_USERS?
> > 2)Which views will contain information for user PUBLIC.
> > 3) in "OCP Oracle 91 Database:Fundimentals 1 Exam Guide" it says
> > "When a privilege is granted to the user PUBLIC, every user in the
> > database can use the privilege. However, whe a privilege is revoked from
> > PUBLIC, every stored procedure, function,. or package in the database
must
> > be recompiled."
> >
> > Is this true? It does not seem to be. I granted select on scott.item to
> > PUBLIC. Then I revoked select on scott.item from PUBLIC. All of the
> > functions and procedures owned by SYS were still valid and not in need
of
> > recompilation. Am I missing something here?
> >
> > 4) Which view can be queried to see information about grants to PUBLIC.
None
> > of the views mentioned in the book seem to contain this information.
> > (DBA_ROLES, DBA_ROLE_PRIVS,DBA_SYS_PRIVS)
> > TIA
> > Mike
> >
> >
>
> *) Public is a role ... not a user. So it won't show up in dba_users.
> *) Views like dba_roles etc. explicitly have been coded to filter out info
for Public role.
>
> Look around catalog.sql and things will be clearer to you.
>
> ....
>
> Anurag
>
>
Received on Sun Nov 30 2003 - 00:43:47 CST