반응형
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 |
---|