Which permissions are needed to add new users to NAV SQL DB

Emerik

Hi,
Can anyone tell me which permissions/rights are needed for adding new database users in NAV and synchronize them correctly.

It seems like NAV role SUPER is not enough, but that permissions on the SQL Server are also required. With Server Role Sys_adm and NAV role SUPER, it is possible to add new users and synchronize security, but we do not wish to give everyone Sys_adm role, if a lower security setup could do the trick?

Can anyone answer me or link to documentation about this?

Thanks in advance.
Emerik

rmpatel22

I faced this problem before and got solution from Mibuso.

See post http://www.mibuso.com/forum/viewtopic.php?f=23&t=37155

If your security mode is "Advanced", only sa user can add more users in Navision (You can't add more users with super)

Emerik

Thank you for your reply, even though I hoped for another answer :?

David_Singleton

Why are you using Extended Security.

bbrown

Why does everyone need the ability to add users? Typically you would have one (or a very limited number) of administration accounts.