Symptoms

• User has the content of the correct dashboard, but the dashboard picker shows a different dashboard name.
• Dashboard picker is blank, where the dashboard name is empty, but it is displaying the correct dashboard content
• After drilling down to a report/widget on the dashboard and when using the browser/instance back button to go back to dashboard, the user experiences the issue, where the contents of the dashboard does not match with the dashboard name shown in the dashboard picker.

Release

Upgraded from a version earlier than Istanbul to Istanbul or later.

Cause

Enabling the session debug, you will see that the user does not have read access to dashboard_w_permission database view, as per the following screenshot -

 

 

 

 

 

 

The ACLs evaluated and failing are pa_dashboards read ACLs. The database view dashboard_w_permission joins pa_dashboards and pa_dashboards_permissions tables.

Resolution

Starting from Istanbul, there is no need to create ACLs for database views, as the system honours the ACLs on the underlying tables. However, for upgraded instances, the admins need to create the system property glide.security.expander.view.legacy and set it to false, in order to use the new behaviour where the system honours the ACLs on the underlying tables in the database view.

Additional Information

ACLs and database views [Madrid]