Home » RDBMS Server » Security » Modify profile to Use the old password (Windows server,10.2.0.3)
Modify profile to Use the old password [message #472636] Mon, 23 August 2010 02:09 Go to next message
sekar52
Messages: 141
Registered: May 2010
Location: Mumbai
Senior Member
Hi

I have a database in which a user xxxx is assigned a password 'bbbbb'.I want to change the password to the one which was used before which was 'aaaaa'.But when I change the password it was saying "Password cannot be Reused".So I checked in user profile and found out that password_reuse_time=unlimited and password_reuse_max=5.

So what I did was change the password 6 times to something else(Since it is 5) and then tried changing it to 'aaaaa' but still it is saying "Old password cannot be reused".

Can you help me solve this problem?
Re: Modify profile to Use the old password [message #472641 is a reply to message #472636] Mon, 23 August 2010 02:15 Go to previous messageGo to next message
Michel Cadot
Messages: 66654
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Copy and paste:
1/ The user row in DBA_USERS
2/ The profile row in DBA_PROFILES
3/ Your whole session of password changes

Regards
Michel

Re: Modify profile to Use the old password [message #472648 is a reply to message #472641] Mon, 23 August 2010 02:33 Go to previous messageGo to next message
sekar52
Messages: 141
Registered: May 2010
Location: Mumbai
Senior Member
Read some documents and got it cleared Michel but still can you tel me how to set Password_reuse_time to One second or 1 minute.


Thanks
Re: Modify profile to Use the old password [message #472661 is a reply to message #472648] Mon, 23 August 2010 03:16 Go to previous message
Michel Cadot
Messages: 66654
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
It is in days, 1/24=one hour, 1/1440=one minute.

Regards
Michel
Previous Topic: Error at adding logfile in logminer process
Next Topic: Oracle SIM Login Failed
Goto Forum:
  


Current Time: Tue Oct 22 16:09:05 CDT 2019