- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
02-26-2020 01:26 PM
We are trying to do an audit on report access and I've found that the best table to use is sys_report_users_groups . The only issue with this is that the table visibility is only available for admins. We were able to create a database view joining sys_report and sys_report_users_groups so that we can create a report on these tables; however, users who are not admins cannot access the report or the database view.
Any suggestions on how to make this accessible? Would this require a new ACL?
We really would only need admins and report_admins to have access to this database view.
Thanks!
Solved! Go to Solution.
- Labels:
-
Reporting
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
02-26-2020 02:11 PM
You can add report_admin role in the role section of ACL.
And forgot to mention in my earlier post, since sys_report_users_groups is a system table you won't be able to find it in the dropdown table selection.
Follow the below doc to add this table available for reporting.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
02-26-2020 02:11 PM
You can add report_admin role in the role section of ACL.
And forgot to mention in my earlier post, since sys_report_users_groups is a system table you won't be able to find it in the dropdown table selection.
Follow the below doc to add this table available for reporting.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
02-26-2020 03:26 PM
This is a better approach than a view that is just bypassing this restriction.