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

From: Michel Cadot <micadot{at}altern{dot}org>
Date: Mon, 25 Apr 2005 06:21:12 +0200
Message-ID: <426c7004$0$20469$626a14ce@news.free.fr>

<mschott14_at_hotmail.com> a écrit dans le message de news:1114373184.392681.204400_at_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!!!

I think this is because "audit alter session" audit the "alter session" privilege use and not the "alter session" statement execution and that "alter session set cursor_sharing" does not need "alter session" privilege whereas "alter session set sql_trace" needs it.

Till now i don't find a way to audit/prevent "alter session set cursor_sharing".

Regards
Michel Cadot Received on Sun Apr 24 2005 - 23:21:12 CDT