Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Can't change the password even after disabling verification

TomDec 21 2011 — edited Dec 21 2011
DB version: 11.2
OS : Solaris 10

We have a password verification function by which a password can be reused only after 50 different password changes.
But I want to disable this verification and re-use a password .

SCOTT user's profile is DEFAULT. I set DEFAULT profile's password verify function to NULL
select profile from dba_users where username = 'SCOTT';

PROFILE
------------------------------
DEFAULT

SQL> ALTER PROFILE DEFAULT LIMIT PASSWORD_VERIFY_FUNCTION NULL;

Profile altered.

SQL> select * from dba_profiles where resource_name='PASSWORD_VERIFY_FUNCTION';

PROFILE                        RESOURCE_NAME                    RESOURCE LIMIT
------------------------------ -------------------------------- -------- ----------
DEFAULT                        PASSWORD_VERIFY_FUNCTION         PASSWORD NULL


SQL> password SCOTT
Changing password for SCOTT
New password: 
Retype new password: 
ERROR:
ORA-28007: the password cannot be reused
I tried the below as well, but still getting ORA-28007 error
alter user scott identified by xxxx ;
Any idea why this is happening?
This post has been answered by 770839 on Dec 21 2011
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jan 18 2012
Added on Dec 21 2011
4 comments
7,238 views