Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: sqlplus login question

Re: sqlplus login question

From: Jeremy Russell <jeremy.russell.deletethisbit._at_usa.net>
Date: 1999/03/05
Message-ID: <36dfbf8c.1188140@news.earthlink.net>#1/1

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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US