Minimum permission in SQL for NAV users?

jaiverma2k2

What is the minimum permission required on SQL server to nav user to their normal work without backup/restore/user creation permission??.

Regards,
Jai :?:

garak

public

kriki

And don't forget this:
If you choose the simple security model in NAV, then you finished here. With the enhanced security model you need to do synchronization on the NAV client.

jaiverma2k2

Will you please giode me on simple security & enhanced security model.
we have a nav5.0 runnning on SQL server 2005 (with windows login).

:?:

garak

NAV -> file -> Database -> Alter -> Advanced -> Security -> Model

It's to hot in my office, and im so to lazy to write so many words ... so follow the LINK or these LINK

Regards

kine

With Windows logins you do not need to change anything on the SQL. The security model have no effect to it. If you want to know more about secutity models, read the chapter 4.1 of the w1w1isql.pdf documentation...