Issue
When applying the interactive filter on any dashboard and the filter is applied but the filter choices are not stored in preferences, when navigating back to the dashboard the widgets are loaded with the default filters.
Steps to reproduce:
- Impersonate the affected user.
2. Open any Dashboard with interactive filters.
3. Apply interactive filters.
4. Navigate away from the dashboard.
5. Navigate back and note the interactive filter is set back to default.
Release
All current releases that have the com.snc.read_only.role plugin enabled.
Cause
- Any user assigned with the role snc_read_only will experience this issue.
2. Please review the documentation: Read-only role
Note: After you assign this role to a user, they can no longer create, update, or delete records on ANY table.
Resolution
- There are system properties that can be configured to grant access to a specific table to users with read only roles:
- glide.security.snc_read_only_role.tables.exempt_create
- glide.security.snc_read_only_role.tables.exempt_write
- glide.security.snc_read_only_role.tables.exempt_delete
- There are some default values that are already part of the exempted table list as explained in the documentation: Read-only role properties
To resolve this issue:
- Add the table sys_canvas_preferences to the default list of tables on the properties mentioned above.
Note: If the system properties do not exist, you can create them by adding them to the sys_properties table. Please ensure you add all the default tables and sys_canvas_preferences to the system properties mentioned above.