You could consider creating a profile where you set failed_login_attempts to
1.
Regards
HJR
--
----------------------------------------------
Resources for Oracle: http://www.hjrdba.com
===============================
"Andy Hardy" <newsnov01_at_ahardy.demon.co.uk> wrote in message
news:$m4zViFOihE8Ew8O_at_ahardy.demon.co.uk...
> In message <KboQ7.7261$Sj1.2912623_at_typhoon.ne.mediaone.net> , Murty
> Adavi <adavi_at_mediaone.net> writes
> >How do I make PLSQL NOT prompt 3 times for correct login/password info.
> >I am calling PLSQL from a shell script and I want it to exit out if
> >login/password
> >is wrong and not wait for correct login/password.
> >
>
> That's not PL/SQL prompting, it's the SQL*Plus session that you are
> starting up.
>
> Perhaps you should try to verify the password in one call to the
> database before you try to log onto it with your desired PL/SQL script?
>
> Andy
>
> --
> Andy Hardy. PGP ID: 0xA62A4849
> ===============================================================
Received on Sat Dec 08 2001 - 16:22:53 CST
