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: Matthias Hoys <idmwarpzone_NOSPAM__at_yahoo.com>
Date: Fri, 22 Apr 2005 20:20:21 +0200
Message-ID: <42694066$0$28077$ba620e4c@news.skynet.be>

<mschott14_at_hotmail.com> wrote in message 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
>

Don't grant your users the ALTER SESSION privilege. CREATE SESSION should be enough for simple connections.

Matthias Received on Fri Apr 22 2005 - 13:20:21 CDT

Original text of this message

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