We need query to get information about enterprises roles assigned to users.

[vaibhav05]

Hi Team, 

We need query to get information about enterprises roles assigned to users.

Thanks in advance.

[indra_hema_95 · Accepted solution]

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

[Amit_Malik]

@vaibhav05 

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'