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 5 years ago 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.