User PUBLIC questions

From: Michael J. Moore <NOhicamelSPAM_at_comcast.net>
Date: Sun, 30 Nov 2003 03:50:33 GMT
Message-ID: <dOdyb.358587$HS4.3001555@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 Received on Sat Nov 29 2003 - 21:50:33 CST