Hi @Sid_Takali
Users are unable to view the report because they lack report_view ACL access on the database view, which ServiceNow requires even if the report is shared. Additionally, users must have read access to all underlying tables within the database view; otherwise, security restrictions will prevent the report from displaying.
To resolve this, please create a report_view ACL on the database view and grant access to the necessary roles. Report sharing alone does not override security requirements. Also, confirm that users have read access to all tables referenced in the database view, as ServiceNow enforces table-level security before showing report data.
Here are the clear steps to create a report_view ACL in ServiceNow:
Steps to Create report_view ACL
1. Navigate to ACL
Go to: System Security → Access Control (ACL)
Click New
2. Fill Basic Details
Type: record
Name: Your Database View Name (example: u_my_db_view)
Operation: report_view
3. Grant Access
In Requires role section:
Add the roles (ex: itil, custom role, etc.)
OR leave empty (not recommended for prod)
4. Save the ACL
Click Submit
Example
Type: record
Name: u_incident_user_view
Operation: report_view
Roles: itil
Final Check
Make sure users also have read access to underlying tables
If this response addressed your question, please mark it as Helpful and accept it as the solution.
