Unfortunately, you can connect with a userid/password of a sysdba user, but still not able to perform sysdba functions unless you specify "as sysdba". In PRO*C, you would have to:Originally posted by gopi
Can you use a valid user with sysdba privs?
but I can't figure out how to do it in Perl...Code:EXEC SQL CONNECT :sys IDENTIFIED BY :SYS-PASSWD IN SYSDBA MODE END-EXEC.




Reply With Quote