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: <mschott14_at_hotmail.com>
Date: 22 Apr 2005 17:31:04 -0700
Message-ID: <1114216264.206974.274220@l41g2000cwc.googlegroups.com> 





right, so product_profile_table is useless for me since it is only
useful for SQL*Plus.



But the point is, even granting the users ONLY "CREATE SESSION" they
will be able to issue


ALTER SESSION set cursor_sharing=xxxx!! Even explicitly revoking the
ALTER SESSION Privilege they still will be able to do am ALTER SESSIONE
set cusrsor_sharing=xxx!!!! But I need a way to PREVENT this. I still
dont see a solution for this here in the above statements :(



Regards,


Michael
Received on Fri Apr 22 2005 - 19:31:04 CDT












Original text of this message













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