ORB User and Assigned Roles

➜ Back to Library
Description
Categories: ORBIT
All the Orbit Users and their Assigned roles which will help to find out which user has the required roles assigned
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
Parameter NameSQL textValidation
User Name
ou.id=:user_id
LOV
Role Name
oro.name= :role_name
LOV
EBS Authority User
ou.authority_user_id=xxen_util.user_id(:created_by)
LOV
Download
Related Blitz Reports
ORB Report Assignment Details ORB Business Object and Assignments OKL Termination Quotes ORB Report Execution History ORB Report Execution Summary ORB Report and Details RK: AR Transactions and Lines Avalara VAT Report ORB Report Columns
Blitz Report™