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

Emerik
Emerik Member Posts: 50
edited 2010-07-06 in SQL General
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

Comments

  • rmpatel22
    rmpatel22 Member Posts: 80
    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)
    Rakesh Patel
    Navision Developer
  • Emerik
    Emerik Member Posts: 50
    Thank you for your reply, even though I hoped for another answer :?
  • David_Singleton
    David_Singleton Member Posts: 5,479
    Why are you using Extended Security.
    David Singleton
  • bbrown
    bbrown Member Posts: 3,268
    Why does everyone need the ability to add users? Typically you would have one (or a very limited number) of administration accounts.
    There are no bugs - only undocumented features.

Categories