Re: oracle account suddenly change to lock???
- From: Stefan Knecht <knecht.stefan@xxxxxxxxx>
- To: mccdba1@xxxxxxxxx
- Date: Sat, 21 Nov 2009 17:08:25 +0100
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@xxxxxxxx
10046 Consulting GmbH
Schwarzackerstrasse 29
CH-8304 Wallisellen
Switzerland
Phone +41-(0)8400-10046
Cell +41 (0) 79 571 36 27
info@xxxxxxxx
http://www.10046.ch
=========================
On Sat, Nov 21, 2009 at 4:48 PM, dba1 mcc <mccdba1@xxxxxxxxx> 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.
>
>
>
>
> --
> //www.freelists.org/webpage/oracle-l
>
>
>
Other related posts:
