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
| Parameter | Type | List of values SQL | |
|---|---|---|---|
| User Name | LOV |
| |
| Role Name | LOV |
| |
| EBS Authority User | LOV |
|