Oracle Password expiration settings and password change issues

Oracle Password expiration settings and password change issues

Studied: https://jingyan.baidu.com/article/ce09321b5608612bff858ff3.html

Sqlplus/as  Sysdbaselect * from Dba_profiles s where s.profile= ' DEFAULT ' and resource_name= ' password_life_time '; Alter profile default limit password_life_time Unlimited;alter user username identified by PASSWORD;

When changing the password, if the password has an @ symbol,

Studied: http://blog.itpub.net/29067253/viewspace-2144617/

Use double quotes to enclose, user login need to use single quotation mark to enlarge double quotation mark;

Alter user username identified by "[email protected]";
Sqlplus ' user/"[email protected]" '

Oracle Password expiration settings and password change issues