Re: User PUBLIC questions

Michael J. Moore wrote:
>
> 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
> >
> >

Under the covers, users and roles are very very similar (both being stored in the same table if I recall correctly). Run a query from USER$ as SYSDBA, so some "overlap" in what they do and don't do can probably be expected.

hth
connor Received on Sun Nov 30 2003 - 01:50:33 CST