Skip to content

Oracle Database: Reset User Password and disable passowrd expiration.

cpx October 17, 2013 1 min read Database Oracle/ORA_PMON/1521
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;

 

Be the first to comment

protected · no tracking

0 comments