At 10:23 -0500 27/4/01, Jay Strauss wrote: >$ 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: If you don't need to be sysdba (and really you don't since you won't be able to do the only two distinguishing actions: startup and shutdown), I suggest that you look at external authentication. Very short course: # useradd -g dba scripter SQL> alter user ops$scripter identified externally; % sqlplus / $user = $passwd = ''; $dbh = DBI->connect( $dsn, $user, $passwd ) Note that the external identification prefix (here shown as the default 'OPS$' may have to be defined in your init.ora file (os_authent_prefix = ops$. Regards Paul Miller -- - Carib Data Limited <mailto:[EMAIL PROTECTED]> <http://www.caribdata.co.uk>
