Re: ALTER SESSION in a system event trigger?

In article <9gvb6d$lk$1_at_oslo-nntp.eunet.no>, "Rosy" says...
>
>I'm trying to do a 'ALTER SESSION SET NLS_DATE_LANGUAGE=.....' in an 'AFTER
>LOGON ON DATABASE' system event trigger . Gets error PLS-00103 from the
>parser ('..found ALTER but expected one of the following:....').
>Is this operation illegal in triggers on system events?
>
>Any help would be appreciated.
>
>Rolf
>
>

see
http://osi.oracle.com/~tkyte/Misc/RolesAndProcedures.html

the OWNER of the trigger needs to be granted the ALTER SESSION privelege directly, not via a role.

--
Thomas Kyte (tkyte@us.oracle.com)             http://asktom.oracle.com/ 
Expert one on one Oracle, programming techniques and solutions for Oracle.
http://www.amazon.com/exec/obidos/ASIN/1861004826/  
Opinions are mine and do not necessarily reflect those of Oracle Corp