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:
|
To grant permissions in SQL Server
-
Open SQL Server Management Studio and connect to your instance of SQL Server.
-
In the left pane, click Databases, select a database, click Security, and then click Users.
-
In the Users pane, right-click the user that needs permissions, and on the shortcut menu, click Properties.
-
Under Database role membership, select relevant privileges, and then click OK.