System Table storing who dashboards are shared with

PB7
Mega Guru

- Context: -

'sys_report_users_groups' is the system table where a record exist for instance of a Group or User that a Report is shared with.


E.g.  

"Report X" is shared with "Group I"  and "User P" -- therefore there is a sys_report_users_groups record for "Report X" being shared to "Group I" and another sys_report_users_groups  record for "Report X" being shared with "User P".  

This can be observed in the attached [PFA-0] snip.

 

- Issue: -

My issue is I cannot find a system table to account for the Groups or Users that Dashbaords are shared with. 

Does anyone know which system table holds records accounting for  this? 
E.g. [PFA-1] attached

 

1 ACCEPTED SOLUTION

AndersBGS
Tera Patron
Tera Patron

Hi @PB7 ,

 

You should look at pa_dashboards_permissions

 

AndersBGS_0-1696484647784.png

If my answer has helped with your question, please mark my answer as accepted solution and give a thumb up.

 

Best regards

Anders

If my answer has helped with your question, please mark my answer as the accepted solution and give a thumbs up.

Best regards
Anders

Rising star 2024
MVP 2025
linkedIn: https://www.linkedin.com/in/andersskovbjerg/

View solution in original post

2 REPLIES 2

AndersBGS
Tera Patron
Tera Patron

Hi @PB7 ,

 

You should look at pa_dashboards_permissions

 

AndersBGS_0-1696484647784.png

If my answer has helped with your question, please mark my answer as accepted solution and give a thumb up.

 

Best regards

Anders

If my answer has helped with your question, please mark my answer as the accepted solution and give a thumbs up.

Best regards
Anders

Rising star 2024
MVP 2025
linkedIn: https://www.linkedin.com/in/andersskovbjerg/

Brilliant -- that's the one! Thanks so much Anders.