SELECT * FROM dba_profiles s WHERE s.profile='DEFAULT' AND resource_name='PASSWORD_GRACE_TIME';
5、修改默认宽限期限为无限(可不设置):
ALTER PROFILE DEFAULT LIMIT PASSWORD_GRACE_TIME UNLIMITED;
6、查看过期用户的相关信息:
select a.username,a.profile,a.account_status,a.EXPIRY_DATE from dba_users a, dba_profiles b where a.profile=b.profile and b.resource_name='PASSWORD_LIFE_TIME' and ACCOUNT_STATUS in ('EXPIRED(GRACE)','EXPIRED');
dba_profiles相关参数详解
SQL> SELECT * FROM DBA_PROFILES WHERE PROFILE='DEFAULT' AND RESOURCE_NAME LIKE 'PASSWORD%';