Click HERE to see how Saviynt Intelligence is transforming the industry. |
05/22/2024 05:09 PM
I'm looking to develop a report that shows the privileges assigned to all users and how they were assigned. Specifically, I'd like to know if the privileges were assigned via a role or through other methods like birthright or ad hoc access requests. Do you have any insights or suggestions on how I could go about creating this report? Thank you.
05/22/2024 08:05 PM
SELECT a.name,ev.entitlement_Value ,at.source
FROM accounts a
JOIN account_Entitlements1 ae ON ae.accountkey = a.accountkey
JOIN entitlement_Values ev ON ev.entitlement_Valuekey = ae.entitlement_Valuekey
LEFT JOIN arstasks at ON ae.ARSTASKKEY=at.taskkey
WHERE a.endpointkey = 3
AND a.name = '137658'
AND ev.entitlementtypekey = 5