Unexpire Oracle Password

Tags: Oracle, password reset, unexpire, expire, expiration, reset, password, profile

Saturday, August 11, 2018 2:02:37 PM

sourc:  http://www.dba-oracle.com/t_unexpire%20password.htm

Step 1: Create a profile to use by all Oracle ID's:
 
create profile
   my_profile limit
   password_life_time unlimited;

Step 2: Alter all users to use this profile in SQL*Plus:

spool runme.sql
set heading off
select 'alter user '||username||' profile my_profile;' from all_users;
spool off|
@runme   

1 Comment

  • verasearch3 said Reply

    ALTER PROFILE DEFAULT LIMIT COMPOSITE_LIMIT UNLIMITED
    PASSWORD_LIFE_TIME UNLIMITED
    PASSWORD_REUSE_TIME UNLIMITED
    PASSWORD_REUSE_MAX UNLIMITED
    PASSWORD_VERIFY_FUNCTION NULL
    PASSWORD_LOCK_TIME UNLIMITED
    PASSWORD_GRACE_TIME UNLIMITED
    FAILED_LOGIN_ATTEMPTS UNLIMITED;

You must log on to comment.