Unless I'm missing something, can't you just do a show parameter utl_file_dir in the respective databases to list all directories accessible? As for java, something like this: SELECT kind, grantee, type_schema, type_name, name, action, enabled FROM dba_java_policy Look for a TYPE_NAME = java.io.Filepermission ________________________________ From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Pakhutkin, Maxim (Max) Sent: Wednesday, January 11, 2006 1:08 PM To: oracle-l@xxxxxxxxxxxxx Subject: tracing oracle filesystem access Does anyone know of a way to trace/audit which files and directories oracle accesses either via PL/SQL (utl_file_dir) and java? I'm trying to restrict java access and pl/sql access to the filesystem, but would like to be able to monitor existing access patterns to make sure I will not break any functionality when I apply the restriction. The only way I can think of is by monitoring server processes with truss, but that would be pretty cumbersome. The other way is to somehow put a wrapper around sys.utl_file (but what about java?). Thanks in advance. Max Pakhutkin -- http://www.freelists.org/webpage/oracle-l