如何设置Oracle数据库用户密码长期有效

1、一、环境确认su - oracle$sqlplus / as sysdbaSQL> desc 颊俄岿髭dba_profiles; SQL> select LIMIT from dba_profiles where RESOURCE_NAME='PASSWORD_LIFE_TIME';

2、二、修改过程SQL>alterprofiledefaultlimitPASSWORD_LIFE_TIMEUNLIMITED;

3、三、确认修改已成功SQL> select LIMIT from dba_profiles where RESOURCE_NAME='PASSWORD_LIFE_TIME';SQL> exit