SQL server role for managing user on NAV 6.02

(0) Share

Report

Posted on by ch405

Hi guys,

I'm discussing necessary SQL server roles and rights for NAV users to be able to add and delete NAV users.

I do not believe that SQL 'sysadmin' role is necessary in order to manage users in NAV, but what are the POLP (Principle of Least Privilege) rights then?

Thanks.

I have the same question (0)

All responses (1)

Answers (0)

Suggested answer

Stefano Demiliani 37,166 Most Valuable Professional on at

Like (0)

Report

User permissions for Dynamics NAV is setup within the application. However you need to provide the necessary user permission to the users in SQL level so that they can access the Dynamics NAV database (you need to have a user able to add users to a SQL database).

Was this reply helpful? Yes No