News and Announcements icon

Dynamics 365 CommunityForums Small and medium business | Business Central, N... SQL server role for ma...

Small and medium business | Business Central, N...

Suggested answer

SQL server role for managing user on NAV 6.02

(0) Share

Report

Report

Posted on by ch405

5

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.

All responses Img

All responses (1)

Answers Img

Answers (0)

Suggested answer

Stefano Demiliani 37,166 Most Valuable Professional on at

Like (0)

Report

RE: SQL server role for managing user on NAV 6.02

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

Helpful resources

Quick Links

Leaderboard

#1

André Arnaud de Cal... 294,349 Super User 2025 Season 1

#2

Martin Dráb 233,029 Most Valuable Professional

#3

nmaenpaa 101,158 Moderator

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans