Hi all. Dbase Newbie here. I am trying to create the below view. I need to retrieve every user with an assigned group and what roles the groups have. I will also need data such as the department and other. I intended to further granulate my data inside a report, using this view.
However, I get no records returned in the below view.
help please
Stacylen
For sys_user my fields are department, sys_id, roles, user_name, name
For sys_user_grmember, my fields are user, group, sys_id
For sys_group_has_role, my fields are sys_id, role, group
