X-list: oracle-l Return-Path: Subject: Re: tracing oracle filesystem access From: Paul Drake Message-id: 910046b40601111136j6e1b3145g8121171d6717ce6e@mail.gmail.com Date: 2006-01-11 20:36:37 On 1/11/06, Pakhutkin, Maxim (Max) wrote: > > 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 > Max, Agent Smith would say "Your people are already dead". http://www.cert.org/tech_tips/win-UNIX-system_compromise.html Paul