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> 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