OraFAQ Forum: Security » Change of password

Home » RDBMS Server » Security » Change of password

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Change of password [message #267326]

Thu, 13 September 2007 01:03

deepthi.jaju
Messages: 2
Registered: September 2007
Location: Hyderabad

Junior Member

In one of our database,the user is scott and password is tiger.Then the passowrd was changed to lion.Now when ever we are trying to open the database in toad,we are getting an error saying account is locked.The error is ORA-28000.Then we are unlocking the account using an alter statement by entering as sysdba.Then we are able to open the database.But daily the same is happening.Whenever we are trying to open the database it is saying account is locked.Again we need to run the alter statement and unlock it.Can any one tell why is this happening?Or any suggestion what do rectify this error.

Report message to a moderator

Re: Change of password [message #267330 is a reply to message #267326]

Thu, 13 September 2007 01:07

Michel Cadot
Messages: 68722
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

I think when you said opening the database you meant connecting as scott.
You have to first see what profile is associated to scott (query dba_users) then know the profile parameters (query dba_profiles).
There likely is a limit on number of failed connections, so you have to find which process try to connect as scott.

Regards
Michel

Report message to a moderator

Re: Change of password [message #267338 is a reply to message #267326]

Thu, 13 September 2007 01:25

Frank
Messages: 7901
Registered: March 2000

Senior Member

Do you do a nightly restore?
Do you run a nightly batch that tries to logon as scott/tiger and locks out the account?
Do you open TOAD with 'automatic' logon?
How many invalid logons are allowed?

[Edit: hmm, shouldn't be talking so long between typing & posting, now Michel already answered this Smile

]

[Updated on: Thu, 13 September 2007 01:26]

Report message to a moderator

Previous Topic:	ROLE - PRIV mapping
Next Topic:	Why does ORACLE calls VPD function twice on every DML?

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Dec 12 08:55:17 CST 2024