Oracle用户密码过期设置
-------------------------设定用户超时--------------------
SELECT username,profile FROM dba_users;
SELECT * FROM dba_profiles s WHERE s.profile='DEFAULT' AND resource_name='PASSWORD_LIFE_TIME';
ALTER PROFILE DEFAULT LIMIT PASSWORD_LIFE_TIME UNLIMITED;
22:02:34
------------------解锁、更改用户密码----------------------
ALTER USER username ACCOUNT UNLOCK;
select * from dba_users where username='MCMDB_DEV';
alter user MCMDB_DEV identified by "Res_MCMDB_DEV_3
SELECT * FROM dba_profiles s WHERE s.profile='DEFAULT' AND resource_name='PASSWORD_LIFE_TIME';
ALTER PROFILE DEFAULT LIMIT PASSWORD_LIFE_TIME UNLIMITED;
22:02:34
------------------解锁、更改用户密码----------------------
ALTER USER username ACCOUNT UNLOCK;
select * from dba_users where username='MCMDB_DEV';
alter user MCMDB_DEV identified by "Res_MCMDB_DEV_3
