I am trying to get a list of user who do not have a particular resource provisioned. I cannot seem to find a table that links the resource object information and User information. I need to generate a CSV file. Has anyone done this before or have any ideas. If so any information would be very helpful.
select * from usr where usr.usr_key not in (
select usr.usr_key from oiu, usr, obi, obj, ost
and obj.obj_name = :obj_name
and ost.ost_status not in ('Revoked'))