Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: How to audit/trigger "ALTER SESSION" Statements?
<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