Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Microsoft Dynamics NAV (Archived) / permissions on master ...
Microsoft Dynamics NAV (Archived)

permissions on master database?

(0) ShareShare
ReportReport
Posted on by Community Member Microsoft Employee

Hi all of you, I am recently DBA for Navision ERP and I have got a couple of 2014 Always On with its two nodes where I see that in every node, all of them, in master database dozens of end-user have permissions... just for sys schema (sysprocesses object)

Before to proceed or ask further as a Navision newbie, do you have any clue why is it done? Navision infrastructure could require that end-user had access or permissions on MASTER database. It is very strange to me.

Thanks for your hints and replies,

*This post is locked for comments

  • Suggested answer
    Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: permissions on master database?

    You also don't need these users in SQL in NAV 2016 like AX.

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: permissions on master database?

    AFAIK all of them are using RDS via remote desktop. Thanks for your response

  • Suggested answer
    Alexander Ermakov Profile Picture
    Alexander Ermakov 28,094 on at
    RE: permissions on master database?

    There are different things: how users access the application and what are the authentication types.

    For authentication types used please refer to: msdn.microsoft.com/.../hh169371(v=nav.90).aspx . Windows authentication applies user credentials used in Active Directory.

    Then, users can access the application via native windows client (which can be installed either on their own laptops or using RDS and running the client from this terminal server), or via web client, or recently via tablet client: msdn.microsoft.com/.../hh168534(v=nav.90).aspx

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: permissions on master database?

    Let me understand one thing. All the connections are through by using RDS connections. Nonetheless end-users are created as login in my SQL Server cluster... I don't understand that. Does Navision really needs user domains in SQL Server?

    As opposed to AX environments you don't need to do that. is it so?

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: permissions on master database?

    Thanks for that

  • Suggested answer
    Alexander Ermakov Profile Picture
    Alexander Ermakov 28,094 on at
    RE: permissions on master database?

    Generally, it should not be the case; however there might be such business processes that require users to perform specific operations which are unusual, but require such setup.

    If there is no documentation regarding the setup structure for user rights (which is most likely the case :-) ), I would recommend to take permissions from one user and see if he cries out for help, if you have reasons to believe it is not business-critical process he deals with.

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: permissions on master database?

    most users have permissions on sys.sysprocesses. Curious.

    Thanks for your reply

  • Suggested answer
    Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: permissions on master database?

    As per my understanding, It is not mandatory to have permission on Master database. You may remove it and check for one of the user in test environment and see if you are facing any error.

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

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,280 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,235 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans