Re: user "PUBLIC" not in All_USERS

>thanks Pete. I was looking at the TYPE#=0 but never looked in DBA_ROLES.
>But ...
>
>Connected to:
>Oracle Database 10g Enterprise Edition Release 10.1.0.2.0 - Production
>With the Partitioning, OLAP and Data Mining options
>
>SQL> sho user
>USER is "SYS"
>SQL> conn system/manager
>Connected.
>SQL> sho user
>USER is "SYSTEM"
>SQL>
>
>Daniel Morgan
>

Hi Daniel,

You missed the "as sysoper", it is this bit that connects you to the public schema, but this is the misnomer!!. Its the same as "as sysdba" connecting you to the SYS schema.

kind regards

Pete

-- 
Pete Finnigan
email:pete_at_petefinnigan.com
Web site: http://www.petefinnigan.com - Oracle security audit specialists
Book:Oracle security step-by-step Guide - see http://store.sans.org for details.