ORB User and Assigned Roles

Description

Categories
ORBIT
All the Orbit Users and their Assigned roles which will help to find out which user has the required roles assigned

SQL 13 lines

select ou.login orb_user_login_name,
xxen_orb_util.orb_user(ou.id) orb_user_name ,
oro.name role_name,
oro.description role_description ,
xxen_util.user_name(ou.authority_user_id) authority_ebs_user_name ,
ou.email orb_user_email
from xxorb.orb_user_role our, 
xxorb.orb_user ou,
xxorb.orb_role oro
where 1=1 and
our.user_id=ou.id and
our.role_id=oro.id
order by ou.id

Parameters 3

ParameterTypeList of values SQL
User NameLOV
ou.id=:user_id
Role NameLOV
oro.name= :role_name
EBS Authority UserLOV
ou.authority_user_id=xxen_util.user_id(:created_by)