You’re offline. This is a read only version of the page.
130
Good Morning
Please tell me how to setup permission on SQL
regards,
Rakesh Gupta
*This post is locked for comments
Hey Rakesh,
Permission on SQL is not something which is generic, its some thing user dependent and the level of permission you want to give.
Check out this link
User permissions for Dynamics NAV is setup within the application. However you need to provide the necessary user permission to the users in SQL level so that they can access the Dynamics NAV database. Refer below links on how to provide related access to the users using SQL Management Studio.
Hi Rakesh,
Basically, You need to setup the Users & Related Roles & Permission in NAV.
Check these links for creating users in SQ & NAV. Also, to assign the roles & permission to that particular user.
msdn.microsoft.com/.../dd355093(v=nav.71).aspx
blogs.msdn.microsoft.com/.../basic-sql-creating-users-in-nav-on-sql
saurav-nav.blogspot.ae/.../nav-2013-r2-role-permission-wizard.html
mibuso.com/.../nav-2013-r2-roles-permission-wizard
msdn.microsoft.com/.../dd355357(v=nav.71).aspx
Please mark the answers as verified, if it helps you resolving your issue.
Hi Rakesh,
Please check this link: msdn.microsoft.com/.../dd568727(v=nav.70).aspx
If you have specific questions about setting up permissions, we are happy to answer.
Hope it helps.
#1
Sohail Ahmed
2
#1
mmv
2
#1
Amol Salvi
2
Share
Report
All responses (
Answers (
