View the list of affected reports
You can view a list of all impacted reports identified by the ACL assessment for reports. Use this list to remediate affected reports and users.
Before you begin
Roles required: admin and security_admin.
Procedure
Navigate to All > Reports > ACL Assessment for Reports > Affected Reports List.
The list report shows the affected reports.
| Column | Description |
|---|---|
| Report | The report name with a hyperlink to its form. |
| Table | The source table of the report. |
| DBView Referenced ACL Table | When this column is populated, the report is affected because of an ACL on one of the tables that the database view is based on.Sometimes an affected report is based on a database view with an ACL. In this case, the name of the database view appears below the name of the table in the Table column. |
| Dot Walk Fields | When this column is populated, the report is affected because of an ACL on an extended table. For more information, see Report on extended tables. |
| Total executions | The number of times a user has viewed the report. This column is empty if the property run_scan_based_on_report_execution_only is false. |
| Last execution | The timestamp of the most recent time execution of the report. This column is populated if the property run_scan_based_on_report_execution_only is true. |
| is global | True / False. If true, the report owner has shared it with all users. If false, the report owner has shared it with specific users, groups, or roles. |
| Shared to roles | Roles the report owner has shared it with \(regardless of access control list\). This field is empty if the report is global. |
| Shared to users | Users the report owner has shared it with \(regardless of access control list\). This field is empty if the report is global. |
| Shared to groups | Groups the report owner has shared it with \(regardless of access control list\). This field is empty if the report is global. |
| Is blocked by read ACL | This column shows true if a read ACL blocks a user. |
| Read ACL table | Shows the name of the table checked if the user is blocked by a read ACL. |
| Is blocked without RVA or Read ACL | This column shows true if a report is blocked because the table the report is based on has neither a report\_view ACL nor a read ACL. |
| Blocked by table ACLs | If a table ACL \(or column ACL that applies to all columns in a table\) blocks a user, this column shows the name of the ACL. |
| Blocked by table ACLs roles | The roles defined in the table ACL whose members can view reports based on the ACL. A user needs at least one of these roles to see the report. |
| Table ACLs link | Click the link to view a list of the table ACLs that apply to the impacted report. The Role field in the list shows the required roles. A user must have one of the roles to view reports based on the table. |
| Blocked by column ACLs | If a specific column ACL blocks a user, this column shows the name of the ACL. |
| Blocked by column ACLs roles | The roles defined in the column ACL whose members can view reports based on the column. A user needs at least one of these roles to see the report. |
| Column ACLs link | Click the link to view the column ACLs that apply to the impacted report. The Role field in the list shows the required roles. A user must have one of the roles to view reports based on the column. |
- Address the affected reports and users as described in Manage Report ACL assessments.
Parent Topic:ACL Assessment for Reports