3 Replies Latest reply: Jul 29, 2011 11:44 AM by orauser RSS

    OEM changes user's password by default when adding a role!!!

    orauser
      We're experiencing an odd behavior on several windows/oracle 10g systems.

      If we use Oracle Enterprise Manager to add a role to a user, it automatically changes the password to an unknown value! Is that strange or am I missing something?

      Here's the SQL OEM executes when I add a role:

      ALTER USER "TESTUSER" IDENTIFIED BY "*******"
      GRANT "MYROLE" TO "TESTUSER"
      ALTER USER "TESTUSER" DEFAULT ROLE ALL

      From here on out the testuser account has an unknown password, has anyone else experienced this behavior?

      I tested this on a different machine running 11g and linux and it does't act the same. Is this a windows/10g bug?

      Edited by: orauser on Jul 29, 2011 8:37 AM