Is any way to set num of failed attempt?

 Is there a way to set the number of login attempts
for SQL*Plus?  Is there a setting for this in the login.sql
or glogin.sql file?  ie.,

SET ATTEMPTS = 1

  Or, can this be done on the command line?  ie.,


Ans:
Yep, you can set this but it's a PROFILE feature, not handled in
LOGIN.SQL.  You need connect as the SYSTEM or other DBA account, then
issue a statement similar to this: <check the syntax>

SQLPLUS> ALTER PROFILE DEFAULT FAILED_LOGIN_ATTEMPTS = 1;

The DEFAULT profile is always active, at least the PASSWORD limits are
if not the KERNEL limits.  If this doesn't need to apply to all users,
then create a new profile with the desired setting and ALTER USER to
set that new profile to their accounts.
 

Hosted by www.Geocities.ws

1