Re: Forcing an ALTER SESSION at session startup

From: Jonathan Lewis <jonathan_at_jlcomp.demon.co.uk>
Date: Thu, 19 Oct 2000 17:03:38 +0100
Message-ID: <971971774.28538.0.nnrp-13.9e984b29@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 Thu Oct 19 2000 - 11:03:38 CDT

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