oracle password expiration help

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:

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:

LIMIT RESOURCE_NAME —————————————- ——————————– 180 PASSWORD_LIFE_TIME . . . → Read More: oracle password expiration help