Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: sqlplus login question
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.
NB - this is for Oracle V8 and better.
HTH Jeremy Russell
pat mercer <pmercer_at_verio.net> wrote:
>Hello,
>
> 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.,
>
>sqlplus -s user/pass_at_server [some paramater]
>
>
>Thanks,
>
>-pat mercer
Received on Fri Mar 05 1999 - 00:00:00 CST