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

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
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

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

I have the same question (0)
  • Suggested answer
    Community Member Profile Picture
    Community Member on at

    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.

  • Community Member Profile Picture
    Community Member on at

    most users have permissions on sys.sysprocesses. Curious.

    Thanks for your reply

  • Suggested answer
    Alexander Ermakov Profile Picture
    Alexander Ermakov 28,096 on at

    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 on at

    Thanks for that

  • Community Member Profile Picture
    Community Member on at

    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?

  • Suggested answer
    Alexander Ermakov Profile Picture
    Alexander Ermakov 28,096 on at

    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 on at

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

  • Suggested answer
    Community Member Profile Picture
    Community Member on at

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

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…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics NAV (Archived)

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans