identityidentity-managementoimidentitymanager

Is there a SQL query to get userwise provisioned account in OIM?


I need a query to check if the account is provisioned to user from database.

Any clues?


Solution

  • Query to get all the enabled/provisioned accounts to specific user:

    SELECT OBJ.OBJ_NAME
    FROM OBJ,OBI,OIU,OST,USR
    WHERE OBJ.OBJ_KEY=OBI.OBJ_KEY
    AND OBI.OBI_KEY=OIU.OBI_KEY
    AND OIU.USR_KEY=USR.USR_KEY
    AND OIU.OST_KEY=OST.OST_KEY
    AND OST.OBJ_KEY=OBJ.OBJ_KEY
    AND USR.USR_LOGIN='[Insert User Login here]'
    AND OST.OST_STATUS IN ('Enabled','Provisioned');