You see ALL users.

-----Original Message-----
From: Hinds Andrew [mailto:oracledba-ezmlmshield-x70276964.[Email address protected]
Sent: Friday, August 31, 2007 10:57 AM
To: LazyDBA Discussion
Subject: RE: Visible users

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




---------------------------------------------------------------------
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