SQL*PLUS Login Attempts

[dayankoven]

Hi there fellow forumers,

I've got a situation in which i'm logging on to SQLPLUS from a UNIX Command prompt. By default SQL*Plus will prompt from 3 login attempts when the login is unsuccessful due to invalid password/username. The command line call seems to be waiting for a response after the 1st attempt has failed.
Is there a way i could limit the login attempt to only 1 try and exit once this attempt fails. I'm on Oracle 8.
Thanks in advance for all the help.

 

[HimanB]

No. Three login attempts is the default.

It's not possible to override this feature as the logic is hard-coded
in the SQL*Plus source code.

Regards
Himanshu

 

[sem]

You may connect from within script itself:

script test.sql:

whenever sqlerror exit
accept username prompt "Enter User Name "
accept password prompt "Enter Password "
connect &&username/&&password

select 1 from dual
/

call it:

sqlplus /nolog @test



Regards, Dima