SQL ligin aproach.

eriksi

](*,) ](*,) ](*,) ](*,) ](*,) ](*,)

Hello, I have a problem with SQL/NAV integration. I do not know how to configure SQL Server to the rights granted through NAV only. Currently I have configured the SQL database users with DBO ownership over the database. Such a scenario I do not like, as the user navigates through the database. I wonder how I can create users so they can work in Nav and don't have direct access to SQL server.

Thank you for your time.

kriki

Go to file=>Database=>Alter=> tab advanced : change field "Security=>Model" to standard.
No more need to Synchronize logins and you can give only public rights to the logins.

BTW: to do that you need to put the DB in singleuser mode through NAV and then you can change it.

eriksi

Thank you for your swift response.
I will try this solution and see what happens.

Thanks

stryk

Maybe this also could help you a little: http://dynamicsuser.net/blogs/stryk/archive/2010/02/16/extended-database-hardening-nav-sql.aspx