Re: Schedule SQL*Plus on NT

From: XU <xux_at_informa.bio.caltech.edu>
Date: 13 Jul 1999 20:46:59 GMT
Message-ID: <7mg8k3$mpu@gap.cco.caltech.edu>

You may want to place the user/password in the script.sql file itself, if you need the desired behavior - sql*plus will abort if the usr/password is incorrect.

Robert Xu

Corey G. (corey_gill_at_my-deja.com) wrote:
: I would like to schedule some sql*plus scripts on Windows NT. A
: scheduled cmd file starts sql*plus like this:

: sqlplus user/password_at_dbname script.sql scriptparm1

: The only problem I have is that if the username/password or db connect
: string is incorrect, sql*plus will remain on the console prompting for
: another username. Is there any way to get sql*plus to abort and exit
: if the first connection attempt fails ? Or are there better ways to
: handle this ?

: Also, is using the sqlnet.ora parameter: sqlnet.authentication_services
: = (NTS) considered secure ?

: BTW, I'm using 8.04, but have tried sqlplus on 805 and 815 and get the
: same behaviour.

: Thanks,
: --
: Corey Gill
: corey_gill_at_hotmail.com

: Sent via Deja.com http://www.deja.com/
: Share what you know. Learn what you don't.
Received on Tue Jul 13 1999 - 15:46:59 CDT