Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> How to audit/trigger "ALTER SESSION" Statements?
Hello all,
Is there a way to audit "ALTER SESSION" Statements submitted to the
database?
I tried system event triggers (ON DLL; ON ALTER; etc), but ALTER
SESSION does not seem to fire on anyone of those triggers.
Alternatively it seems that anybody can issue the statement ALTER
SESSION SET cursor_sharing=force EVEN when ALTER SESSION is beeing
revoked from the user.
How can I revoke this specific statement from a user?
Any hints are incredibly welcomed
Michael Received on Fri Apr 22 2005 - 09:29:46 CDT