Click HERE to see how Saviynt Intelligence is transforming the industry. |
09/09/2024 04:23 AM
Hi Team,
We need query to get information about enterprises roles assigned to users.
Thanks in advance.
Solved! Go to Solution.
09/09/2024 04:35 AM - edited 09/09/2024 04:36 AM
Hi @vaibhav05
select u.username,r.role_name from users u, role_user_account rua, roles r where rua.userkey=u.userkey and rua.rolekey=r.rolekey and r.roletype=4;
try this please.
Regards,
Indra
09/09/2024 04:36 AM - edited 09/09/2024 04:59 AM
select u.username,r.role_name from users u
Join user_accounts ua ON u.userkey=ua.userkey
JOIN role_user_account rua ON rua.accountkey=ua.accountkey
Join roles r ON r.rolekey=rua.rolekey
where r.roletype='4'