QUOTE (suresh_oradba @ Nov 23 2007, 01:15 PM)
In sys.user$ view, there is an additional column type# which is (probably- I haven't checked docs)
0 for roles
1 for schemas
If it is so, then public is more a 'role' than a 'schema'.
well, you will not find the internal tables in the doc, do not search!
PUBLIC is neither in DBA_ROLES nor in DBA_USERS. And Oracle used the term PUBLIC SCHEMA more than once, but I would rather say PUBLIC is special, you cannot drop, create or alter PUBLIC. Under certain circumstances, public is seen a schema, as it is an OWNER in all_objects
SQL> connect / as sysoper
SQL> show USER
USER is "PUBLIC"