Share
ReportGood Morning
Please tell me how to setup permission on SQL
regards,
Rakesh Gupta
*This post is locked for comments
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.
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,269
Super User 2024 Season 2
#2
Martin Dráb
230,198
Most Valuable Professional
#3
nmaenpaa
101,156
All responses (
Answers (