Oracle Database: Reset User Password and disable passowrd expiration.

● cpx October 17, 2013 1 min read Database ORACLE/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;

0 0 votes

Article Rating

0 Comments

Oldest

Newest Most Voted

Oracle Database: Reset User Password and disable passowrd expiration.

SQL Performance Optimization: Finding the Right Queries to Fix

MySQL vs MongoDB

Oracle unix DBA group