connecting automatically as sys

Ok,

I have a bizarre one - I want to automate a script that uses the 'sys' user, but when I try to log in via sqlplus:

sqlplus sys/.....@......

I get the message 'permission denied: sys should connect as sysdba'.

but when I try:

sqlplus sysdba/.....@.....

I get the message 'incorrect password'. So - I *can* do:

connect sys/.....@..... as sysdba

at the beginning of the script - but I'm loathe to do this because I don'
want the user/password string in the sql file.

So - how can one cleanly automate this? Preferably, I'd want to do this all from environmental variables so I don't have the password displayed at all inside the process table...

thanks much,

jon Received on Thu Jul 15 2004 - 23:56:27 CDT