
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
07-28-2017 07:41 AM
ACLs around the cmn_rota tables use the "hasroleingroup" function which looks for a role granted by the specific group tied to the ROTA. First off, we don't want all of our users within the group tied to a ROTA to be a ROTA Manager. Secondly, when I grant the role to the group, the User Role is marked as inherited but not as Granted By.
I cannot find any documentation on how to set Granted By on a User Role.
If anyone understands the ROTA ACL mechanism and how to properly setup the groups, I would love to hear how.
Thanks in advance,
AA
Solved! Go to Solution.

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
07-28-2017 10:29 AM
Take a look at the OOB 'Delegate roles to group member' catalog item. You can delegate the role for a specific group (i.e. only rota_manager for a specific group). On the sys_user_has_role table, this should result in a record that has the granted by set to the group.

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
07-28-2017 10:29 AM
Take a look at the OOB 'Delegate roles to group member' catalog item. You can delegate the role for a specific group (i.e. only rota_manager for a specific group). On the sys_user_has_role table, this should result in a record that has the granted by set to the group.

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
07-28-2017 10:42 AM
Thanks, I'll try this out and see if it gets us the functionality we need. If so, I'll mark as correct answer. Thanks again.