Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: How to audit/trigger "ALTER SESSION" Statements?

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

From: <mschott14_at_hotmail.com>
Date: 22 Apr 2005 09:00:17 -0700
Message-ID: <1114185616.969492.301700@o13g2000cwo.googlegroups.com> 





Hello,


thanks for your answers.


I can audit at least the submitted ALTER SESSIONS (I see it in
AUDIT_TRAIL), but I have no plan of either how to trigger or how to
prevent especially the ALTER SESSION set cursor_sharing=xxx command.
I dont find any product_profile_table under the system schema, but I do
find for example the sqlplus_product_profile table?
How am I supposed to find and then to use such a table?



Thanks again, Michael
Received on Fri Apr 22 2005 - 11:00:17 CDT












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US