Re: sqlplus login question

So is there any way of achieving the same effect with Oracle 7.3? Or some way to fudge it? I want to run SQL*Plus in batch mode, but I don't want it sitting there behind the scenes prompting for a username if the user has entered an invalid username/password combination.

Thanks

Una

In article <36dfbf8c.1188140_at_news.earthlink.net>,   jeremy.russell.deletethisbit_at_usa.net wrote:
> 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
>
>

-----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own Received on Tue Mar 30 1999 - 00:00:00 CST