RE: JDBC and login.sql
Date: Wed, 27 Feb 2008 13:35:01 -0500
Message-ID: <21469B88E0EA11498818517F2103353101C65FB4@EPRI17P32001A.csfb.cs-group.com>
To the best of my knowledge, only SQL*Plus reads login.sql. You should
be able to do what you want with a login trigger; you can identify the
specific users by executing the sys_context function and examining the
pertinent 'userenv' values.
Paul Baumgartel
CREDIT SUISSE
Information Technology
Prime Services Databases Americas
One Madison Avenue
New York, NY 10010
USA
Phone 212.538.1143
paul.baumgartel_at_credit-suisse.com
www.credit-suisse.com
From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Crisler, Jon
Sent: Wednesday, February 27, 2008 1:29 PM
To: oracle-l_at_freelists.org
Subject: JDBC and login.sql
Does the login.sql get run if a user connects to a 10g db via JDBC ? I want to put some specific settings for specific JDBC users....such as "alter session set session_cached_cursors" and the only way I can think of is via login.sql.
Please access the attached hyperlink for an important electronic communications disclaimer:
http://www.credit-suisse.com/legal/en/disclaimer_email_ib.html
-- http://www.freelists.org/webpage/oracle-lReceived on Wed Feb 27 2008 - 12:35:01 CST