Re: Forcing an ALTER SESSION at session startup - How?

I'm using 7334.

What is the obsolete parameter, if you think it would work for me?

Thanks!

"Jonathan Lewis" <jonathan_at_jlcomp.demon.co.uk> wrote in message news:971971774.28538.0.nnrp-13.9e984b29_at_news.demon.co.uk...
>
> There is an 'obsoleted' parameter.
> However for 8.1.6 you could create a
> database-level trigger
> create trigger XYZ on logon ......
>
> This can be made global (any logon to database)
> or for a specific user (SCOTT.schema).
>
> It is best to test logon triggers against a single
> schema before going global.
>
>
> --
>
> Jonathan Lewis
> Yet another Oracle-related web site: http://www.jlcomp.demon.co.uk
>
> Syltrem wrote in message ...
> >Hi!
> >
> >I would like to do an
> >ALTER SESSION ISOLATION_LEVEL=SERIALIZABLE
> >when any user session starts (not in SQL*Plus!). This is for testing
> >purposes, and if the users (or application) like it I may need it for the
> >prod db.
> >
> >Is there a way to do this? Is there a startup parameter that will do it?
> >
> >Thanks!
> >
> >
> >
>
>
Received on Fri Oct 20 2000 - 13:24:20 CDT