I’m using Oracle 11g and was really confused on how the password expiration date was set (default values).
To retrieve the default password expiration values set for all new users run this query:
|
1 2 3 |
select LIMIT, RESOURCE_NAME from dba_profiles where RESOURCE_NAME in ('PASSWORD_GRACE_TIME','PASSWORD_LIFE_TIME','PASSWORD_REUSE_MAX','PASSWORD_REUSE_TIME'); |
Your output should look something like this:
|
1 2 3 4 5 6 |
LIMIT RESOURCE_NAME ---------------------------------------- -------------------------------- 180 PASSWORD_LIFE_TIME UNLIMITED PASSWORD_REUSE_TIME UNLIMITED PASSWORD_REUSE_MAX 7 PASSWORD_GRACE_TIME |
To find all users that have a password expiring in the next 120 . . . → Read More: oracle password expiration help
