RE: JDBC and login.sql
Date: Wed, 27 Feb 2008 12:39:44 -0600
Message-ID: <3B8B6A1700202C43A89D61CE495C894E0D2BB3E46F@MSPM1BMSGM103.ent.core.medtronic.com>
The way to do this is with a login trigger. login.sql only gets executed for sqlplus connections.
Pat
From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Crisler, Jon Sent: Wednesday, February 27, 2008 12: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.
[CONFIDENTIALITY AND PRIVACY NOTICE] Information transmitted by this email is proprietary to Medtronic and is intended for use only by the individual or entity to which it is addressed, and may contain information that is private, privileged, confidential or exempt from disclosure under applicable law. If you are not the intended recipient or it appears that this mail has been forwarded to you without proper authority, you are notified that any use or dissemination of this information in any manner is strictly prohibited. In such cases, please delete this mail from your records.
To view this notice in other languages you can either select the following link or manually copy and paste the link into the address bar of a web browser: http://emaildisclaimer.medtronic.com
-- http://www.freelists.org/webpage/oracle-lReceived on Wed Feb 27 2008 - 12:39:44 CST