Saturday, August 19, 2017

Setting oracle user password to same password

Followed this blog: http://www.dbas-oracle.com/2013/04/Keep-Same-Password-for-Oracle-User-when-Expiry-Time-Reached.html

First off caveat emptor regarding disabling Oracle security features by following the steps in this and the referenced blog.

On Windows Server 2008, hit Windows button and enter sqlp, then enter.
SQL> connect / as sysdba
SQL>select username, profile from dba_users where username = 'SOMEUSERNAME';
USERNAME ----...---PROFILE
------------------------------------
SOMEUSERNAME....DEFAULT
SQL>alter profile DEFAULT limit password_verify_function null;
Profile altered.
SQL>alter user someusername identified by somepassword;
User altered.
After this user should be able to log in using the same password without the ORA-28002 error.

No comments:

Post a Comment