Applies to Product – Dynamics 365 Business Central
What’s happening?
Inquiring about the possibility of restricting access to specific columns or rows within a table in Dynamics 365 Business Central, rather than restricting access at the table level.
Reason:
The underlying cause of this is related to the limitations of the security filter functionality in Dynamics 365 Business Central, which currently allows for record-level security but does not support column-level access control.
Resolution:
- It is confirmed that security filters can be set to control record access for users, which allows for limiting access to specific rows in a table.
- However, there is no functionality available to control access at the column level within a table.
- For managing access for different departments, it is recommended to create custom permission sets:
- One permission set can be created for users who need access to all data in the table (without security filters).
- Another permission set can be created for users who should only access part of the table, utilizing security filters to restrict their view based on the criteria set.
- If there are specific fields or columns that need to be restricted, it is advised to reach out to the publisher of any third-party extensions for further assistance.