Re: How to audit/trigger "ALTER SESSION" Statements?

mschott14_at_hotmail.com wrote:

> 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

http://www.psoug.org
click on Morgan's Library
click on DDL triggers

-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu
(replace 'x' with 'u' to respond)