This section explains how to implement record-level security in Microsoft Dynamics NAV with Microsoft SQL Server.
Microsoft Dynamics NAV with Microsoft SQL Server allows you to limit the access that users have to the information stored in the database by specifying that they can only access records which fulfill certain criteria in specific tables. This is called record-level security. You implement record-level security by placing security filters on the roles and permissions that you assign to your users.
It is important to remember that when using security filters, the filters must reflect the business logic of your application if you are to avoid problems.
Record-level security has no influence on the business logic of your application but the business logic of your application can have a great influence on record-level security and the filters that you can apply. Record-level security is only useful when it complements or supplements your business logic.