Sunday, June 28, 2026

Fetch the ENT membership details based on Logical ENT attribute

 SELECT
    i.name AS identity_name,
    ma.value,
    ma.DISPLAY_NAME,
    ma.ENT_APP_Name
FROM spt_identity i
JOIN spt_identity_Entitlement ie ON ie.Identity_ID = i.id
JOIN spt_managed_attribute ma ON ma.value = ie.value
WHERE ma.ENT_APP_Name = 'PLV' 
ORDER BY i.name;

No comments:

Post a Comment

IAM, IGA & Identity Security

IAM sets up the employee's account so they can log in and access the application with their credentials. IGA makes sure that access requ...

Featured Articles