1. Get rid of all advertisements and get unlimited access to documents by upgrading to Premium Membership. Upgrade to Premium Now and also get a Premium Badge!

Is it possible to change ACCOUNT_STATUS expired without setting a new password

Discussion in 'SQL PL/SQL' started by jesthr@gmail.com, May 21, 2012.

  1. jesthr@gmail.com

    jesthr@gmail.com Active Member

    Messages:
    23
    Likes Received:
    0
    Trophy Points:
    80
    I have account with EXPIRED status!

    USERNAME ACCOUNT_STATUS EXPIRY_DATE
    ------------------------------ -------------------------------- -----------
    OBIJOBMGR EXPIRED 21-MAJ-12

    I change the profile so:

    ALTER PROFILE DEFAULT LIMIT PASSWORD_LIFE_TIME UNLIMITED;

    The account have the same status
    USERNAME ACCOUNT_STATUS EXPIRY_DATE
    ------------------------------ -------------------------------- -----------
    OBIJOBMGR EXPIRED 21-MAJ-12

    Is it possible to change ACCOUNT_STATUS expired without setting a new password

    Regards!

    Hine
     
  2. zargon

    zargon Community Moderator Forum Guru

    Messages:
    2,345
    Likes Received:
    347
    Trophy Points:
    1,430
    Location:
    Aurora, CO
    No, it is not posible. That is determined by the password lifetime and once expired the password needs to be changed.