Microsoft Dynamics NAV Security
Microsoft SQL Server option – Application role
Microsoft SQL
Server Permissions
Application Role
Microsoft SQL Server Permissions
Application Role
Microsoft Dynamics 4.0 and later …
Prior to Microsoft Dynamics NAV 4.0 …
Microsoft SQL
Server Permissions
Microsoft SQL Server Permissions
“An application role is a database principal that enables an application to run with its own, user-like privileges. You can use application roles to allow access to specific data to only those users that connect through a particular application. “

The Navision Application Role is user specific and contains the SQL permissions for all the Navision objects.

Can only connect through the Navision Client – flips user from SQL permissions to Navision permissions.