Export (0) Print
Expand All
2 out of 3 rated this helpful - Rate this topic

Setting Database Owner and Security Administration Permissions

Microsoft Dynamics Nav 2009

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 then 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.

    GRANT SELECT ON sysprocesses TO [Mydomain\Myuser] with grant option;
    GRANT VIEW SERVER STATE TO [Mydomain\Myuser] with grant option;
    GO
    
  4. Highlight the lines that you just typed, and then 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

Did you find this helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2014 Microsoft. All rights reserved.