When you create a database, you must specify the security model. There are two options:

The Security Model option is on the Advanced tab in the New Database window.

Security Model Differences

Enhanced Security provides an individual layer of protection for each Microsoft Dynamics NAV user. Standard Security does not have this extra layer but can be sufficient for most companies. Using Enhanced Security can impact Microsoft Dynamics NAV performance.

The following table shows the significant differences:

Feature Standard Security Enhanced Security

Synchronization performance

Fast

Slower, especially if you have several companies and many users in the same database

Windows groups available

Local domain plus forest of domains

Local domain only; restricted set of groups available

Logins required in Microsoft Dynamics NAV

Windows groups or individual Windows users

Windows groups plus the members of each group; individual Windows users

Granularity of synchronization

Entire security system

Entire security system and individual logins

Automatic synchronization when you insert, modify or delete a Windows login

Yes

No

Synchronization

Microsoft Dynamics NAV 2009 provides a synchronization mechanism to ensure that information in the SQL Server security system corresponds with the information that is contained in the Microsoft Dynamics NAV security system. When Microsoft Dynamics NAV security is not synchronized with SQL Server security, users may not have the exact database access that the administrator has specified.

When you are running with the Enhanced Security model, there is no automatic synchronization. You must manually synchronize whenever you insert, modify or delete a Windows login. In the Classic client, on the Tools menu, point to Security, and then click Synchronize All Logins.

When to Synchronize

With the Standard Security model, explicit synchronization is only necessary when you are restoring a database from a backup. With the Enhanced Security model, you must manually synchronize the Microsoft Dynamics NAV security system after you:

  • Change the security model.

  • Modify Microsoft Dynamics NAV users, permissions, or roles.

  • Restore a backup.

  • Convert a database.

  • Update the executable files.

  • Update the application.

See Also