I would ask who granted the select on all_source to public? All source
is one of those views anyone can normally access, similar to the views
beginning with user_. I my environment, SYS grants this privilege
during database instance creation.

IJCA,
Gil Bruce

-----Original Message-----
From: Kopejtko Martin Ing.
[mailto:oracledba-ezmlmshield-x82754847.[Email address protected]
Sent: Wednesday, November 28, 2007 10:15 AM
To: LazyDBA Discussion
Subject: all_source

Hi all,

have You any experiences with revoke select on ALL_SOURCE from PUBLIC
??? Is it without dangerous or not?

Thanks a lot!
Martin
###########################################

Zprava byla pred odeslanim testovana systemem F-Secure Anti-Virus for
Microsoft Exchange.


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