Can any one say the table or view under with Access Information of AD Groups exist?
avuser.v_all_groups -> has owner name, members count & entitlement_count, but I am looking for the table that has the entitlement information of AD Groups.
Thanks!
Can any one say the table or view under with Access Information of AD Groups exist?
avuser.v_all_groups -> has owner name, members count & entitlement_count, but I am looking for the table that has the entitlement information of AD Groups.
Thanks!
Select grp.name, xue.entitlement_type, ent.ALT_NAME from T_AV_EXPLODEDUSERENTITLEMENTS xue join T_GROUPS grp on xue.entitled_id=grp.id and xue.entitled_type='group'
join T_ENTITLEMENTS ent on xue.entitlement_id = ent.id and xue.entitlement_type='ent'
where xue.deletion_date is null
union
Select grp.name, xue.entitlement_type, ar.ALT_NAME from T_AV_EXPLODEDUSERENTITLEMENTS xue join T_GROUPS grp on xue.entitled_id=grp.id and xue.entitled_type='group'
join T_ENTITLEMENT_GROUPS ar on xue.entitlement_type='app-role' and xue.entitlement_id= ar.id
where xue.deletion_date is null;
Select grp.name, xue.entitlement_type, ent.ALT_NAME from T_AV_EXPLODEDUSERENTITLEMENTS xue join T_GROUPS grp on xue.entitled_id=grp.id and xue.entitled_type='group'
join T_ENTITLEMENTS ent on xue.entitlement_id = ent.id and xue.entitlement_type='ent'
where xue.deletion_date is null
union
Select grp.name, xue.entitlement_type, ar.ALT_NAME from T_AV_EXPLODEDUSERENTITLEMENTS xue join T_GROUPS grp on xue.entitled_id=grp.id and xue.entitled_type='group'
join T_ENTITLEMENT_GROUPS ar on xue.entitlement_type='app-role' and xue.entitlement_id= ar.id
where xue.deletion_date is null;