3 Replies Latest reply: Dec 3, 2012 4:08 AM by Vedant.. RSS

    How to renew an expired user account ?

    JOE_humble
      Version:11.2.0.1
      OS : RHEL 5.4

      Password for one of our DB user(schema) has expired . The user was using DEFAULT profile
      SQL> select resource_name, RESOURCE_TYPE, limit FROM DBA_PROFILES where profile = 'DEFAULT' AND resource_name like 'PASSWORD%';
      
      RESOURCE_NAME                    RESOURCE LIMIT
      -------------------------------- -------- ----------------------------------------
      PASSWORD_LIFE_TIME               PASSWORD 180
      PASSWORD_REUSE_TIME              PASSWORD UNLIMITED
      PASSWORD_REUSE_MAX               PASSWORD UNLIMITED
      PASSWORD_VERIFY_FUNCTION         PASSWORD NULL
      PASSWORD_LOCK_TIME               PASSWORD UNLIMITED
      PASSWORD_GRACE_TIME              PASSWORD 7
      
      6 rows selected.
      This schema is used only by apps server ie. No manual logins from SQL*Plus or PL/SQL developer .
      Both apps team and me (the DBA) have forgotton the password.
      SQL> select account_status from dba_users where username = 'PARF_CALIB_USR';
      
      ACCOUNT_STATUS
      --------------------------------
      EXPIRED
      
      SQL> alter user PARF_CALIB_USR account unlock;          --- Unlock won't help
      
      User altered.
      
      SQL> select account_status from dba_users where username = 'PARF_CALIB_USR';
      
      ACCOUNT_STATUS
      --------------------------------
      EXPIRED
      I think this can be fixed by setting a new password (ALTER USER parf_calib_usr IDENTIFIED BY newpassword ; )
      But I want to keep the old password and renew this user account. Is this possible ?