If permissions are granted on a Microsoft Dynamics NAV database, the user can only perform database changes for that database. To allow a user to make changes to all databases in a SQL Server instance, grant permissions to the master database.

Database Changes that Require Elevated Permissions

Microsoft Dynamics NAV administrators should be granted the securityadmin Server Role in SQL Server Management Studio. The following table lists areas and actions that require elevated permissions.

Area Action Minimum permissions

Database

Create, test, alter, and delete

db_owner for Microsoft Dynamics NAV databases and the master database

Company

Create, rename, and delete

db_owner for Microsoft Dynamics NAV databases and the master database

Objects

Create, modify, and delete

db_owner for Microsoft Dynamics NAV databases and the master database

License

db_owner for Microsoft Dynamics NAV databases and the master database

Users

Add and synchronize users

db_accessadmin for the master database; db_accessadmin and db_owner for Microsoft Dynamics NAV databases

In addition, you must provide additional privileges by following these steps:

  1. Open SQL Server Management Studio and connect to your SQL Server instance.

  2. On the File menu, point to New, and then click Query with Current Connection.

  3. Type the following SQL statements.

      CopyCode imageCopy Code
    GRANT SELECT ON sysprocesses WITH GRANT OPTION TO [username]
    GRANT VIEW SERVER STATE WITH GRANT OPTION TO [username]
    GO
    
  4. Highlight the lines that you just typed and, on the Query menu, click Execute.

To grant permissions in SQL Server

  1. Open SQL Server Management Studio and connect to your instance of SQL Server.

  2. In the left pane, click Databases, select a database, click Security, and then click Users.

  3. In the Users pane, right-click the user that needs permissions, and on the shortcut menu, click Properties.

  4. Under Database role membership, select relevant privileges, and then click OK.

See Also