Is there Report Share / Permissions Table?

[Kieron Jones]

Hi Community!

As there is with dashboard shares / permissions, a table called pa_dashboard_permissions, is there a similar table for report share / permissions.

When sharing a report one can specify Users / Groups / Roles, where is this information held?

I would like to create a report that lists all reports showing the users / groups / roles that have access to them?

Thanks in advance

Kieron Jones

[Stephen Sturde · Accepted solution]

Hi Kieron,

Report records mostly store their own security information. There is also the Report Users and Groups table. 

When you view reports in under Reports > Administration > All (or sys_report_list.do), you can look at the record attributes including the user, group, and role fields associated with a given report.

• When sharing a report, if "everyone" is selected, the user can specify roles (or not). These are stored in the "Roles" field and the "user" field value on the report record is cleared.
• If "Group" is selected, the "user" field value is set to "Group" but the selected groups are stored in the "sys_report_users_groups_list" table.

Let me know if that's what you're looking for or not.

[Kieron Jones]

Great Info, Stephen! Thanks a lot.

[Thomas_Davis]

Roles are stored in sys_report
Users & Groups in sys_report_users_groups

[Kieron Jones]

Great stuff. Thanks Thomas!