On Wed, 11 Jun 2003 11:00:13 +0100 Tim Bunce <[EMAIL PROTECTED]> wrote:
> ----- Forwarded message from "Baras, Gal" <[EMAIL PROTECTED]> > ----- > > Delivered-To: [EMAIL PROTECTED] > From: "Baras, Gal" <[EMAIL PROTECTED]> > To: "'[EMAIL PROTECTED]'" <[EMAIL PROTECTED]> > Subject: DBD::Oracle question - Can I connect / as sysdba? > Date: Wed, 11 Jun 2003 12:17:58 +1000 > > No point asking the other folks if this is not supported. You delayed getting an answer by several hours by writing to Tim instead of to the list ([EMAIL PROTECTED]) as directed by the fine manual (`perldoc DBI` or http://search.cpan.org/author/TIMB/DBI/DBI.pm). > sqlplus allows the users in the 'dba' group ('oracle' and 'psoft' in > our environment) to use the logon string "/ as sysdba" to gain admin > access to Oracle. Is this supported by DBD::Oracle 1.12? How do I > use this? This was just discussed in this list last week. It is also in the fine manual (`perldoc DBD::Oracle` or http://search.cpan.org/dist/DBD-Oracle/Oracle.pm). Look for ora_session_mode for a specific answer to this question, but it is a good idea to read it all. The only trick is that you should pass "" as both userid and password in DBI->connect(). Note that some installations, maybe most, don't allow '/' logins from remote sessions. -- Mac :}) Give a hobbit a fish and he eats fish for a day. Give a hobbit a ring and he eats fish for an age.
