Database View records require read ACLs created for non-admin users after upgrade to Fuji
Prior to Fuji, if a database view was defined, but you had ACL rights to see the data in the underlying tables, you could view the results returned by the database view. This was incorrect behavior.
Starting with Fuji, we are doing an additional tableLevelACLAllow() check when displaying a list. After upgrade, a non-admin user will not have access to database view records unless a read ACL is created directly on the database view (just like other tables).
Create a read ACL directly on the database view table to allow non-admin users to view database view records.
Type Access Control in the navigation filter.
Select the Access Control (ACL) module.
Select the New action at the top of the list.
Under Operation, select Read, and under Name, select the name of the database view i.e. Incident SLA
- Add the required roles needed to access the database view and click Submit.