Re: trace every SQL statement of a specific user
Date: Fri, 7 Mar 2008 06:10:42 -0800 (PST)
I've already tried it and it worked, thank you. at the risk of being too boring (I guess I already am) the only thing that I'd need for complete satisfaction would be now to limit the tracing to a certain machine.
let's imagine such a situation: there are several copies
of some software in some company. some of them
have to run continuously. but then I'd like to do some workflow
on one machine and then get a trace only from this very machine,
and this very oracle user. Or at least to be able to easily filter the
file for events only from that machine...
I thought about an extension of the trigger with something like:
if user_logging_on_not_from_machine_xxx then return;... this would
make me totally satisfied.
Greetings Received on Fri Mar 07 2008 - 08:10:42 CST