DBMS/Oracle

Solution for making a password never expire

Temporary backups 2021. 3. 24. 00:44
반응형

SQL> connect sys/secret_password as sysdba;

SQL> alter user sysman account unlock ;

-- SQL> alter user DBUSER identified by newpa$$word;


Next, change the profile limit to unlimited.


SQL> alter profile DEFAULT limit PASSWORD_REUSE_TIME unlimited;

SQL> alter profile DEFAULT limit PASSWORD_LIFE_TIME  unlimited;


Check the password expiry date 

 
SQL> select username, account_status, EXPIRY_DATE from dba_users where username='BURLESON';
 
USERNAME                       ACCOUNT_STATUS               EXPIRY_DATE
------------------------------ ---------------------------- ---------
BACMONIT                       OPEN                         UNLIMITED

반응형

'DBMS > Oracle' 카테고리의 다른 글

DIFFERENCE BETWEEN AN EMPTY STRING AND A NULL VALUE IN ORACLE  (0) 2020.05.05