web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

No record found.

Community site session details

Community site session details

Session Id :
Microsoft Dynamics NAV (Archived)

SQL Permission Setup

(0) ShareShare
ReportReport
Posted on by 130

Good Morning

Please tell me how to setup permission on SQL

regards,

Rakesh Gupta

*This post is locked for comments

I have the same question (0)
  • Suggested answer
    Nareshwar Raju Vaneshwar Profile Picture
    5,596 on at

    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.

  • Suggested answer
    Community Member Profile Picture
    on at

    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.

  • Suggested answer
    Alexander Ermakov Profile Picture
    28,096 on at
  • Suggested answer
    Tharanga Chandrasekara Profile Picture
    23,118 on at

    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.

    msdn.microsoft.com/.../hh166150(v=nav.90).aspx

    forum.mibuso.com/.../sql-permissions-for-administrators

  • Suggested answer
    RockwithNav Profile Picture
    8,637 Super User 2025 Season 2 on at

    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

    msdn.microsoft.com/.../dd568727.aspx

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Leaderboard > 🔒一 Microsoft Dynamics NAV (Archived)

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans