Is it possible to restrict particular users (ACL or role based) to Data sources in reporting?

stephenb_ · ‎10-30-2023

Is it possible to restrict the visibility of the Source type to 'Data source'? I'm interested in this to enforce certain best practices such as 'active=true' to tables unless otherwise approved within our instance. I've looked into some suggestions via Google, but generally it circulates around restricting all access to reporting or restricting access to reporting to particular tables. However only granting reporting access to 'sys_report_source' would likely only allow reporting against the tables records and not to using the report sources within it to create reports.

Tai Vu · ‎10-30-2023

Hi @stephenb_

The Data Source in Report is a reference field named "Report source [report_source]" in the Reports [sys_report] table.

So you can try to redefine the Reference Qualifier in Dictionary for the field above.

In the other hand, you can achieve by changing the ACL Read in the Report Source [sys_report_source] table.

ACL: https://<instance_name>/sys_security_acl.do?sys_id=001f5245c331210038bf506adfba8ff0

Sample below.

Let me know if it works for you.

Cheers,

Tai Vu

stephenb_ · ‎11-02-2023

I believe that this isn't the correct approach: I'm not trying to restrict which report sources are available in the drop down. I am trying to restrict 'table' and 'metricbase' from being selectable in the Source Type field.

Tai Vu · ‎11-03-2023

Hi @stephenb_

There's an existing Source Type [source_type] field in the Report [sys_report] table as well.

There's no choices defined in the Dictionary. => That means most probably it's being hard code somewhere in the UI Page.

I don't think we have access to have a look or modify this page sys_report_template.

Cheers,

Tai Vu