Re: User PUBLIC questions

"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:27:31 CST