RE: JDBC and login.sql

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@xxxxxxxxxxxxxxxxx 
www.credit-suisse.com 

 

________________________________

From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Crisler, Jon
Sent: Wednesday, February 27, 2008 1:29 PM
To: oracle-l@xxxxxxxxxxxxx
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
==============================================================================

Other related posts: