Permission for Schema Synchronization (NAV 2017)

vaprog

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?

mohana_cse06

I hope you are a Super user without a company name added against it..

mohana_cse06

I hope you are a Super user without a company name added against it..

ShaiHulud

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

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

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

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!