permission on SQL Server

jaiverma2k2
jaiverma2k2 Member Posts: 112
edited 2009-04-30 in NAV/Navision Classic Client
what is the minimum permission is need to be given to NAV users on MSSQL server?
Please advise

Thanks,
Jai
Regards,
Jai Verma

Comments

  • Fisherman
    Fisherman Member Posts: 456
    At which level? SQL Server permissions or NAV?
  • DenSter
    DenSter Member Posts: 8,307
    Just 'Public', that's all. Not a single additional permission or server role, because those are setup inside the NAV database. Just add the user and assign it to Public. Then you add the user to NAV security, and assign them to roles, which includes individual permissions. If you are on the enhanced security model, you will need to synchronize the user.
    Daniel Rimmelzwaan
    RIS Plus, LLC
  • Fisherman
    Fisherman Member Posts: 456
    If you're on SQL 2005 or 2008, you also need to make sure that the role to which you assign the user also has rights over the schema. One of the more interesting nuances I've found about SQL security post 2000.

Categories