Here in the text for the view ALL_USERS. There is also a public synonym
for the view and public has select on the view. Hope this helps.

VIEW_NAME OWNER
------------------------------ ------------------------------
TEXT
------------------------------------------------------------------------
--------
ALL_USERS SYS
select u.name, u.user#, u.ctime
from sys.user$ u, sys.ts$ dts, sys.ts$ tts


-----Original Message-----
From: Trnka Jiri
[mailto:oracledba-ezmlmshield-x6535328.[Email address protected]
Sent: Friday, August 31, 2007 2:13 AM
To: LazyDBA Discussion
Subject: Visible users

Dear DBAs,

If I connect to a database as non-DBA and run SELECT * FROM ALL_USERS, I
will obtain a list of all users visible to me. How is the "visibility"
defined? Thank you.

Best regards

Jiri Trnka



---------------------------------------------------------------------
TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY To post a
dba job: http://jobs.lazydba.com To Subscribe : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html



Oracle LazyDBA home page