Create report based on sys_report_users_groups table

[Danielle25]

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!

[Adam Stout]

1) You would need to add a new ACL to sys_report_users_groups (and adding access for report_admins seems fine).

2) Why do you need a view?  Why won't a normal dot-walk work?

3) How do you account for group and role access?

[Danielle25]

In our lower environments (where I have admin access) the sys_report_users_groups table is not accessible to be reported on. If this is just a setting that can be changed happy to do that instead of using a database view.

Once I created a DB view as mentioned above I was able to create a report but users without my level of access are not able to see it. So assuming this goes to production where I am a report_admin I would not be able to report on it.

[Prateek kumar]

You would have to create an ACL for report_on.

[Danielle25]

can you limit that ACL to just report_admin role? Where would you do that?