我想从OIM获得被撤销权利的历史吗？由于撤销帐户可以从"帐户"选项卡中看到，但不能看出权利。
您可以使用ENT_ASSIGN_HIST表。
select
ENT_ASSIGN_HIST.ENT_ASSIGN_HIST_KEY
,ENT_ASSIGN_HIST.ENT_LIST_KEY
,ENT_ASSIGN_HIST.VALID_FROM_DATE
,ENT_ASSIGN_HIST.VALID_TO_DATE
,usr.usr_login
,ENT_ASSIGN_HIST.ACT_KEY
,ENT_ASSIGN_HIST.OIU_KEY
,ENT_ASSIGN_HIST.OIO_KEY
,ENT_ASSIGN_HIST.CREATED_BY
,ENT_ASSIGN_HIST.CREATED_ON
from ENT_ASSIGN_HIST, usr
where ENT_ASSIGN_HIST.usr_key=usr.usr_key
and ent_list_key='<ent_key>';