Oracle Database: Reset User Password and disable passowrd expiration.

SQL> select resource_name,limit from dba_profiles where profile='DEFAULT' and RESOURCE_NAME='PASSWORD_LIFE_TIME';

RESOURCE_NAME                    LIMIT
-------------------------------- ----------------------------------------
PASSWORD_LIFE_TIME               180

alter profile DEFAULT limit password_life_time UNLIMITED;
alter user oblicore identified by oblicore;

 

Leave a Reply

Your email address will not be published. Required fields are marked *