permission on SQL Server

jaiverma2k2

what is the minimum permission is need to be given to NAV users on MSSQL server?
Please advise

Thanks,
Jai

Fisherman

At which level? SQL Server permissions or NAV?

DenSter

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.

Fisherman

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.