Is it possible to control field level / cell level permissions in ad hoc report?
For example, a user has permission to create "Person and Employment Info (as of Date)".
The user does not have access to view any employee's compensation details (both recurring and non-recurring). But the user can generate a report for other user's compensation details through the "as of Date' report.
Is there a way to prevent it?
Employee Central: Reporting
Currently it is not possible to restrict this behavior as cell level / field level permission is not respected in Adhoc framework. The overall Role Based Permissions (RBP) functionality for Adhoc framework still does not support it.
- Use Advanced Reporting as it supports field level RBP.
- Provide permission to the user to an already created ad hoc report instead of providing the report creation permission to the user.
RPT-7968, cell level, field level, Does Ad Hoc Respect RBP Permissions in EC , KBA , LOD-SF-EC-REP , Reporting Data , LOD-SF-EC , Employee Central , LOD-SF-ANA-RBP , Roles & Permissions , LOD-SF-ANA-ADH , Adhoc Reports & Report Builder , Product Enhancement