Permission for Schema Synchronization (NAV 2017)

vaprog
vaprog Member Posts: 1,162
in NAV Three Tier
What permissions do I need to being able to sync tables from the development environment.
  • In NAV I am SUPER.
  • On the SQL Server I have the sysadmin server role
  • I am db_owner of the NAV Database
  • This is a single tenant installation, i.e. tenant Default with application and data in the same database

I get 
---------------------------
Microsoft Dynamics NAV Development Environment
---------------------------
You have not been granted permission to perform the current activity.
---------------------------
OK   
---------------------------

I run the development environment on the same server as the NST.
The SQL Server is on a different machine.
I am able to run synchronization with a different user.
Both users are domain users and members of the same domain as are the machines.
The user that is able to successfully run table sync has higher privileges on Windows, but nothing is run elevated.

What privileges are needed where for me to be able to run table sync?

Best Answer

Answers

  • mohana_cse06
    mohana_cse06 Member Posts: 5,506
    Answer ✓
    I hope you are a Super user without a company name added against it..

    -Mohana
    http://mohana-dynamicsnav.blogspot.in/
    https://www.facebook.com/MohanaDynamicsNav
  • ShaiHulud
    ShaiHulud Member Posts: 228
    Is the development environment being run as admin? That is one of the requirements. Sometimes users configure it to be run like that by default to avoid forgetting it, which would explain why you get the erron on one user, but not another
  • vaprog
    vaprog Member Posts: 1,162
    mohana_cse06 wrote: »
    I hope you are a Super user without a company name added against it..

    That's a good question! No it is not. I could not yet check whether this helps, though. I will report back when I find out more.
  • vaprog
    vaprog Member Posts: 1,162
    edited 2023-04-25
    ShaiHulud wrote: »
    Is the development environment being run as admin?

    I have never ever needed to run the development environment with elevated privileges for simple object development.

    This is not the PowerShell NAV Development Shell I was talking about.

    I can't even check if it would help, because the user is not privileged to run the development environment with elevated privileges. It never has been. Still that very same user was able to sync tables before something changed that makes it impossible now.
  • vaprog
    vaprog Member Posts: 1,162
    edited 2023-05-15
    Yes @mohana_cse06, NAV permission groups were restricted to one company. I finally got this changed and now table sync works again, so this was the reason.
    Many thanks for that pointer!

Categories