User with the necessary role cannot see the dashboard.

[John Clyde Ap_a]

A user with the necessary role cannot see the dashboard even though I shared it to the correct role.

It gives me this when I impersonate as the user with the necessary role to view it.

Here's the config of the dashboard.

Am I missing something? Are there any roles I have to add on the cafe managers role for the user to view the dashboard?

~MSB

[John Clyde Ap_a]

Yep, I have edited my previous reply.

 I was able to make the user see the dashboard but I am still getting this 

Which ACL is it referring to and where can I find and edit it?

[Mohith Devatte]

@John Clyde Ap[as there is one type of ACL called report_view type acls 

open your table and check for acls where type is report_view and see the roles given to it 

only users with those roles can see the report 

[John Clyde Ap_a]

Sorry to ask you this but where do I find the report_view type acls? As for the table, I had actually created a new database view for this so there are two tables in the database view and I am not sure as to where will I find its ACL.

Update: Would it be more preferable to create an ACL and target the database view and add the role to it?

 

Update: I have tried it but it still does not work unfortunately.

[Mohith Devatte · Accepted solution]

@John Clyde Ap[as SO IN BOTH THE TBALES YOU NEED TO CHECK one of the table or may be both the tables acls might be restricting

see the below screenshots on how to check .

go to your table list view and right click on any of the columns and click on configure and then security rules 

then do group by operation and there you can find report view acls 

[John Clyde Ap_a]

Hello Mohith,

This is what it shows for the drinks table:

One of the  x_849256_cafe_mana_cafe_drinks, I have already added the roles before

The other x_849256_cafe_mana_cafe_drinks are empty and its just there with default operations.

Table for the multi row:

One of those sc_multi is the one I should be adding the necessary roles the user had for them to be able to see right? If so I tried it but I cannot seem to add the role, there's no insert row for this.