Home » RDBMS Server » Security » Change of password
Change of password [message #267326] Thu, 13 September 2007 01:03 Go to next message
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.
Re: Change of password [message #267330 is a reply to message #267326] Thu, 13 September 2007 01:07 Go to previous messageGo to next message
Michel Cadot
Messages: 68600
Registered: March 2007
Location: Nanterre, France, http://...
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.

Re: Change of password [message #267338 is a reply to message #267326] Thu, 13 September 2007 01:25 Go to previous message
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:

Current Time: Sun Mar 03 21:55:40 CST 2024