Search code examples
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');