5 Replies Latest reply: Feb 21, 2012 9:45 PM by Pallavi Chaudhari RSS

    Steps for re-using the same user id of a deleted user in OIM 11g ?

    878145
      Hello experts,

      By Default, in OIM 11.1.1.5.0 it is not allowing to re-use the same user id of a deleted user.

      Consider a user with user id as "ABCD1234". The user is deleted from OIM and it is not getting displayed in the user search. But in DB we could see that user details with "Deleted" status. Say accidently this hard delete has happened .

      How do we create that user again with same user id ?

      What is recommended for such scenario ?


      Thanks,
      DK
        • 1. Re: Steps for re-using the same user id of a deleted user in OIM 11g ?
          BikashBagaria
          Check: Does OIM Allow Creating Users with Duplicate User IDs? [ID 558163.1]

          -Bikash
          • 2. Re: Steps for re-using the same user id of a deleted user in OIM 11g ?
            Gyanprakash Pandey
            Login to admin console, go to Advanced->System properties. Search for Reuse user login system property. Set this property to true. It'll enable you to reuse user login. Try your use case and let us know.

            regards,
            GP
            • 3. Re: Steps for re-using the same user id of a deleted user in OIM 11g ?
              BikashBagaria
              In addition to above, you will have to drop the unique index from the USR table. Check the metalink article which I mentioned for step by step guide.

              -Bikash
              • 4. Re: Steps for re-using the same user id of a deleted user in OIM 11g ?
                Nishith Nayan
                I suggest disable the unique index instead of dropping it using ALTER INDEX <INDEX_NAME> DISABLE command.


                Better way to handle this do below

                1. disable index

                2. update usr_login for deleted user using sql query eg. xx|usr_login and commit it ( update usr set usr_login='xx'|| usr_login where upper(usr_status)='DELETED')

                3. enable your index
                4. now login to OIM and easily you can create user with the previous user login

                In this case your Index is still enbaled so it won't hamper the performancem, because this index is being used in various places for user search.

                NOTE: disable any other constraints if required. But, I don't think so. Just disabling unique index will allow you to update"

                --nayan                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                           
                • 5. Re: Steps for re-using the same user id of a deleted user in OIM 11g ?
                  Pallavi Chaudhari
                  Ho about using System property ...

                  User Id reuse property
                       

                  Determines whether a deleted user account can be reused. To reuse a deleted user account, assign this property a value of TRUE and drop the unique index for the USR_LOGIN column in the USR table and create a nonunique index. To prevent a user account from being reused, assign this property a value of FALSE.
                       

                  XL.UserIDReuse