Role Audit table not capturing the records which are adding through groups
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎08-23-2017 04:27 AM
Hi All,
In one of my instance Role audit table are not capturing the records where roles are providing through groups.
And in all Granted by groups showing as blank.
Thanks,

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎08-23-2017 04:47 AM
Hi Hussain,
Could you check sys_user_has_role table once. As I did the same & it worked well.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎08-23-2017 04:52 AM
Hi,
Chances are the role was given to the user manually instead of being added to the group. Check if inherited shows false.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎08-23-2017 05:55 AM
The roles provided though groups are working fine and i can see the respective roles on user profiles and role audit table are working fine if roles are directly providing in user profile only its not working when if roles are providing to users through groups its not auditing in role audit table
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎08-23-2017 06:01 AM
I hope the fields granted by group is available on the list.
Now, it could be three reasons,
- The group is inactive
- The role is included in some other role,which again could be included from another role.
- The group also has security_admin or itil_admin or admin role.