| SQL Connection [message #374740] |
Wed, 27 June 2001 09:37  |
salman
Messages: 22
Registered: March 1999
|
Junior Member |
|
|
Hi,
In SqlPlus its prompt you 3 times for correct username and password but i want it only 1 time.
Is there anything which i can change for prompting 1 time and if its fail then quit sqlplus?
Thanks in Advance
Salman Khan
|
|
|
|
|
|
| LIMIT SQL*PLUS FAILED LOGIN ATTEMPT TO 1 INSTEAD OF 3 [message #374752 is a reply to message #374740] |
Thu, 28 June 2001 08:35  |
Salman Khan
Messages: 51
Registered: September 2000
|
Member |
|
|
ookmark Fixed font Go to End
Doc ID: Note:98865.1
Subject: LIMIT SQL*PLUS FAILED LOGIN ATTEMPT TO 1 INSTEAD OF 3
Type: PROBLEM
Status: REVIEWED
Content Type: TEXT/PLAIN
Creation Date: 11-FEB-2000
Last Revision Date: 17-APR-2001
*************************************************************
This article is being delivered in Draft form and may contain
errors. Please use the MetaLink "Feedback" button to advise
Oracle of any issues related to this article.
*************************************************************
Problem Description
-------------------
Currently SQL*Plus provides 3 attempts for the user to login with the
correct username/password before exiting the session. Is it possible
to override the default behavior and limit login attempts to 1?
Solution Description
--------------------
No. Three login attempts is the default.
Explanation
-----------
It's not possible to override this feature as the logic is hard-coded
in the SQL*Plus source code.
.
--------------------------------------------------------------------------------
Copyright (c) 1995,2000 Oracle Corporation. All Rights Reserved. Legal Notices and Terms of Use.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
