2 Replies Latest reply: Feb 8, 2013 9:55 AM by Krishna-Oracle RSS

    ORA_DES_ENCRYPTED_PASSWORD value when altering a user

    989415
      how to check whether password has been change after executing

      ALTER USER "' || user_ || '" IDENTIFIED BY VALUES '''|| new_password_||'''';

      'ORA_DES_ENCRYPTED_PASSWORD' this system event will have null when execute the above but

      after executing this

      ALTER USER "' || user_ || '" IDENTIFIED BY '''|| new_password_value_ ||'''';

      'ORA_DES_ENCRYPTED_PASSWORD' has the encrypted value

      what is the reason for this?

      Thanks in advance!

      Edited by: 986412 on Feb 7, 2013 3:17 AM
        • 1. Re: ORA_DES_ENCRYPTED_PASSWORD value when altering a user
          Harm Joris ten Napel-Oracle
          Hi ,

          you can use it in event triggers to track password changes, for example check note 419942.1,

          greetings,

          Harm ten Napel
          • 2. Re: ORA_DES_ENCRYPTED_PASSWORD value when altering a user
            Krishna-Oracle
            Hi,
            Oracle only tracks the date that the password will expire based on when it was latest changed. So by looking at the DBA_USERS.EXPIRY_DATE and subtracting PASSWORD_LIFE_TIME you can determine when password was last changed. The last password change time can also directly be seen from the PTIME column in dictionary table USER$ (on which DBA_USERS view is based).

            If you have PASSWORD_REUSE_TIME and/or PASSWORD_REUSE_MAX set in a profile assigned to a user account then you can reference dictionary table USER_HISTORY$ for when the password was changed for this account. This will maintain any password which still falls with in the PASSWORD_REUSE_TIME and PASSWORD_REUSE_MAX limits.


            SQL> desc user_history$
            Name Null? Type
            ----------------------------------------- -------- ----------------------------
            USER# NOT NULL NUMBER
            PASSWORD VARCHAR2(30)
            PASSWORD_DATE DATE

            Thanks,
            Krishna