Creating Database Logins on SQL Server

The following example illustrates how to set up a superuser. You can use the same procedure to create the database logins for other users. Users that have been given a database login must use database authentication to gain access to the database.

Before you can give a user a database login, an administrator must give the user a login (using SQL Server Authentication) on the SQL Server that they will be using.

To Set Up a Superuser:

  1. Click Tools, Security, Database Logins and the Database Logins window appears.

  2. In the User ID field, enter the user ID - in this case SUPERUSER. You can type uppercase and lowercase letters as you like - the program will convert all letters to uppercase. You can later change the user ID in this field. Remember that this ID must be identical to the ID of the user's SQL Server login.

  3. In the Name field, enter the name of the user to whom this ID belongs.

  4. In the Expiration Date field, you can enter a final date on which a user will be able to log on to the program. As a security precaution, superusers should not be given a date limitation.

There is no need to enter a password here as that has already been done on SQL Server. When the user wishes to access a Microsoft Dynamics NAV database they will have to enter both their user ID and the password they entered on SQL Server.


The Microsoft Dynamics NAV security system is initiated when you create the first login. The first login should therefore be for a superuser who is given the SUPER role in Microsoft Dynamics NAV. The superuser then owns and administers all access to this database from within Microsoft Dynamics NAV. Until you create a superuser, any user with access to the system can carry out any transactions they want to in a Microsoft Dynamics NAV database.

One of the first things that the superuser should do is create user IDs, either Windows logins or database logins for the other people who will have access to the database and assign roles to these users. Permissions are allocated at company level in Microsoft Dynamics NAV.

Related Topics


Creating Database Logins on Microsoft Dynamics NAV Database Server

Creating Windows Logins

Giving Database Logins a Role

© 2009 Microsoft Corporation. All rights reserved.