--设置oracle数据库永久期限
ALTER PROFILE DEFAULT LIMIT PASSWORD_LIFE_TIME UNLIMITED;
查询oracle数据库时限
SELECT * FROM dba_profiles WHERE profile='DEFAULT' AND resource_name='PASSWORD_LIFE_TIME'
--修改数据库用户密码
alter user CMD_PORTAL identified by PORTAL;
alter user CMD_NTSCHOOL identified by NTSCHOOL;
alter user CMD_UNITYCONSOLE identified by UNITYCONSOLE;
alter user CMD_EXAM identified by EXAM;
alter user CMD_JEECMS identified by JEECMS;
--解锁数据库用户密码
alter user CMD_PORTAL account unlock;
alter user CMD_NTSCHOOL account unlock;
alter user CMD_UNITYCONSOLE account unlock;
alter user CMD_EXAM account unlock;
alter user CMD_JEECMS account unlock;
--查询数据库用户状态
select username,account_status from dba_users