CODEWITHSUNDEEP
identityidentity-managementoimidentitymanager
Chaitanya K
Chaitanya K

Reputation: 1847

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?

Upvotes: 0

Views: 2930

Answers (2)

Pandharinath Mahalle
Pandharinath Mahalle

Reputation: 66

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');

Upvotes: 2

L. Prior
L. Prior

Reputation: 73

Select * from OIU where usr_key = ?;

Join to ORC to see the resource that is provisioned, POL if this is associated with an access policy, OBI to see the approval process.

Upvotes: 1

Related Questions