select * from dba_profiles where resource_type='PASSWORD' and resource_name='PASSWORD_LIFE_TIME'
select * from dba_profiles where username='SYS' and resource_name='PASSWORD_LIFE_TIME'
select * from dba_db_links
select * from dba_profiles where username='SYS' and resource_name='PASSWORD_LIFE_TIME'
select * from dba_db_links
SELECT username,PROFILE,expiry_date FROM dba_users;
设置永不过期
ALTER PROFILE DEFAULT LIMIT PASSWORD_LIFE_TIME UNLIMITED;