Skip to Main Content
Forums

Security Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Query to Find Target System User ID from OIM Database table

Pallavi ChaudhariMay 4 2011 — edited May 6 2011
Hi,


SELECT distinct UD_LAP_USERID FROM UD_LAP4,ost,oiu,obj,usr, obi WHERE oiu.ost_key = ost.ost_key AND obj.obj_key = obi.obj_key AND oiu.usr_key = usr.usr_key and ost_status in ('Provisioned', 'Enabled') and oiu.obi_key=obi.obi_key and obj.obj_name='ROName'


Here UD_LAP4 is the Table associated with Process form.

UD_LAP_USERID this Target System User ID Field.

I need this query to return only those UD_LAP_USERID with given resource status in Provisioned and Enabled. But my query is returning all UD_LAP_USERID even if the specified Resource is Revoked.

Thanks
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jun 3 2011
Added on May 4 2011
#identity-management, #identity-manager, #oim
6 comments
2,110 views