Re: How to audit/trigger "ALTER SESSION" Statements?

From: <mschott14_at_hotmail.com>
Date: 24 Apr 2005 13:06:24 -0700
Message-ID: <1114373184.392681.204400@z14g2000cwz.googlegroups.com>

so the DDL-Trigger obviously doesn't fire for the particular Statement ALTER SESSION set cursor_sharing=force.
To complicate things further:
Even when you try
AUDIT ALTER SESSION
you won't find above Statement in the AUDIT_TRAIL in contrast to what I've said in one of my posts before.
But on the other hand for example you'll find ALTER SESSION set sql_trace=false
in the AUDIT_TRAIL!!!

This particular ALTER SESSION Statement seems to be absolutly not "catchable", not via a DB or DDL Trigger nor through auditing. Some guys out there should have found a solution for that, shouldn't there??
I need a way to capture ALTER SESSION set cursor_sharing=force!!

Thanks, Michael Received on Sun Apr 24 2005 - 15:06:24 CDT