Below SQL queries will remove specified account from user account tab.
Jun 16, 2014 Delete User In OIM Below is the code for deleting the user form OIM database Note: Please don't use this code in project environment.For testing you can use your own environment package org.itnaf.oim11g.test.delete; import java.sql.; public class DeleteUsers //. Once a user is created in OIM, you cannot delete it. As you mentioned, the default behavior for trusted recon user deletion is that the user will be disabled in OIM and revoked from all target apps. Revoking the user will delete the user from the target apps.
1. Delete entry from child table:
DELETE FROM <Replace_Child_Table_Name>
WHERE ORC_KEY IN
(SELECT OIU.ORC_KEY FROM OIU, <Replace_Child_Table_Name> CT
WHERE OIU.ORC_KEY = CT.ORC_KEY
AND OIU.APP_INSTANCE_KEY = (SELECT APP_INSTANCE_KEY FROM APP_INSTANCE WHERE APP_INSTANCE_NAME =
![Manual Manual](/uploads/1/2/6/4/126469325/834855751.png)
);
2. Delete entry from parent table:
DELETE FROM <Replace_Parent_Table_Name>WHERE ORC_KEY IN
(SELECT OIU.ORC_KEY FROM OIU, <Replace_Parent_Table_Name> PT
WHERE OIU.ORC_KEY= PT.ORC_KEY
AND OIU.APP_INSTANCE_KEY = (SELECT APP_INSTANCE_KEY FROM APP_INSTANCE WHERE APP_INSTANCE_NAME = '<Replace_Application_Instance_Name>')
);
3. Delete entry from OIU table:
WHERE ORC_KEY IN
WHERE OIU.ORC_KEY = ORC.ORC_KEY
AND OBI_KEY IN (SELECT OBI_KEY FROM OBI WHERE OBJ_KEY = (SELECT OBJ_KEY FROM OBJ WHERE OBJ_NAME = '<Replace_Resource_Object_Name>'))