Hi,
Preface: I'm not part of this mailing list, so if you respond, please cc me
on the message. I've tried to search the archives, but could not find a
searchable archive (current archives only go back 3 pages), searched google,
read the FAQ... anyway, I apologize if this question gets asked on a regular
basis.
In the past (yesterday), I'd log onto the Unix box as 'oracle' or any id in
the 'dba' Unix group and I could connect to the database like:
$ sqlplus "/ as sysdba"
The benefit to this method, as opposed to:
$ sqlplus system/manager
being, I don't have to include my database password in any script. Does
anyone know how to do this in DBI/DBD-Oracle? I see in the doc you can do
it like:
The ora_session_mode attribute can be used to connect with SYSDBA
authorization
and SYSOPER authorization.
$mode = 2; # SYSDBA
$mode = 4; # SYSOPER
DBI->connect($dsn, $user, $passwd, { ora_session_mode => $mode });
But, this method requires the password. Does anyone know how to do it
without a password?
Jay Strauss
[EMAIL PROTECTED]
_________________________________________________________
Do You Yahoo!?
Get your free @yahoo.com address at http://mail.yahoo.com
