查询有效期 1.select t.username,t.account_status,t.profile,t.expiry_date from dba_users t; 2.select*from dba_profiles where profile='DEFAULT'and resource_name='PASSWORD_LIFE_TIME' 设置密码无限制有效期 alter profile default limit PASSWORD_LIFE_TIME unlimited;