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: Michel Cadot <micadot{at}altern{dot}org>
Date: Fri, 22 Apr 2005 20:46:49 +0200
Message-ID: <42694666$0$12336$626a14ce@news.free.fr>

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

These tables only works with SQL*Plus family as afaik they are the only products to check their content.
If your users use other products (TOAD for instance), this will be useless.

Regards
Michel Cadot Received on Fri Apr 22 2005 - 13:46:49 CDT

Original text of this message

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