Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: How to audit/trigger "ALTER SESSION" Statements?
"Matthias Hoys" <idmwarpzone_NOSPAM__at_yahoo.com> a écrit dans le message de
news:42694066$0$28077$ba620e4c_at_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
|
As Stephen previously said, "create session" is also enough to execute alter session set cursor_sharing=...
Regards
Michel Cadot
Received on Fri Apr 22 2005 - 13:44:59 CDT