Re: oracle account suddenly change to lock???

From: Stefan Knecht <knecht.stefan_at_gmail.com>
Date: Sat, 21 Nov 2009 17:40:53 +0100
Message-ID: <486b2b610911210840g367cdc86l375ba6e727be0240_at_mail.gmail.com>

That would be alter profile default limit failed_login_attempts unlimited;

I'm assuming it's the DEFAULT profile, otherwise check dba_profiles for the name.

The SQL reference also has the complete syntax, BTW.

Cheers

Stefan

---

Stefan P Knecht
CEO & Founder
s_at_10046.ch

10046 Consulting GmbH
Schwarzackerstrasse 29
CH-8304 Wallisellen
Switzerland

Phone +41-(0)8400-10046
Cell +41 (0) 79 571 36 27
info_at_10046.ch
http://www.10046.ch

---

On Sat, Nov 21, 2009 at 5:13 PM, dba1 mcc <mccdba1_at_yahoo.com> wrote:

> Thank you for answer. my profile set "FAILED_LOGIN_ATTEMPTS =10".
>
> how to change it to large?
>
> Thanks.
>
> --- On Sat, 11/21/09, Stefan Knecht <knecht.stefan_at_gmail.com> wrote:
>
> > From: Stefan Knecht <knecht.stefan_at_gmail.com>
> > Subject: Re: oracle account suddenly change to lock???
> > To: mccdba1_at_yahoo.com
> > Cc: "oracle-l-freelists" <oracle-l_at_freelists.org>
> > Date: Saturday, November 21, 2009, 11:08 AM
> > Hi
> >
> > Check dba_profiles for any limits that may cause an account
> > to be locked -- namely failed_login_attempts (would results
> > in account being LOCKED after too many bad attempts), or
> > password_life_time (would result in it becoming EXPIRED).
> >
> >
> >
> > Cheers
> >
> > Stefan
> >
> >
> >
> > =========================
> >
> > Stefan P Knecht
> > CEO & Founder
> > s_at_10046.ch
> >
> > 10046 Consulting GmbH
> > Schwarzackerstrasse 29
> >
> >
> > CH-8304 Wallisellen
> > Switzerland
> >
> > Phone +41-(0)8400-10046
> > Cell +41 (0) 79 571 36 27
> > info_at_10046.ch
> > http://www.10046.ch
> >
> > =========================
> >
> >
> >
> >
> >
> > On Sat, Nov 21, 2009 at 4:48 PM,
> > dba1 mcc <mccdba1_at_yahoo.com>
> > wrote:
> >
> >
> > we have ORACLE 10GR2 on Linux server. More of account on
> > our database will sudden change to "lock".
> >
> >
> >
> > I check DB parameter "resource_limit" and it set
> > to "false".
> >
> >
> >
> > any ideal?
> >
> >
> >
> > Thanks.
> >
> >
> >
> >
> >
> >
> >
> >
> >
> > --
> >
> > http://www.freelists.org/webpage/oracle-l
> >
> >
> >
> >
> >
> >
> >
> >
>
>
>
>
>

--
http://www.freelists.org/webpage/oracle-l

Received on Sat Nov 21 2009 - 10:40:53 CST