Oracle密码过期设置和修改密码问题
学习了:https://jingyan.baidu.com/article/ce09321b5608612bff858ff3.html
sqlplus / as sysdba
select * 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;
修改密码的时候,如果密码带有@符号,
学习了:http://blog.itpub.net/29067253/viewspace-2144617/
需要使用双引号进行包围,用户登陆需要使用单引号扩上双引号;
alter user username identified by "pass@word";
sqlplus 'user/"pass@word"'