What SQL permissions do you need to upload a Dynamics NAV license file?

Whenever you get a new license file from your partner, in order to activate the new license file, you need to upload the license file to your server. However, sometimes, you may get an error when uploading the license file. So far, I have seen two error messages, that users usually¬†get: The following ODBC error […]

Error: You do not have permission to read the 0 table.

There are quite a few error messages you can get when setting up Dynamics NAV security – database is invalid or cannot be access, you do not have permissions to read the table, etc, etc. And once you have seen them, next time you will know (more or less) possible solution for it. And I […]

What Permissions Do You Need to Take FBK Backup in Dynamics NAV?

Yesterday, I have written quite a simple (and, to be fair, quite boring) post about how to take FBK backup in Dynamics NAV. However, I have not mentioned, what kind of permissions you need to have, in order to be able to take FBK backup. And if you would ask seasoned Dynamics NAV consultants what […]

How to enable Tools > Zoom function in Dynamics NAV?

If you are a developer, most likely you have never had to ask how to enable Tools > Zoom function in Dynamics NAV, because you would normally be a SUPER user in development environment. And, if you have a SUPER role, you have access to this menu option anyway. However, if you are not a […]

What is Permissions Property in Dynamics NAV Object?

I have explained how to find and add permissions in Dynamics NAV, if you start getting error messages: You do not have permission to read TABLE table. However, there is another way (which is sometimes necessary for developer to use rather than for end-user) – assinging permissions directly to Object (table, form, report, dataport, xmlport, […]

Error: You do not have permission to read the table

Dynamics NAV permissions can be either a very simple topic (if you need to add a table permissions to existing security setup), or a very complex one (if you need to create security roles/permissions from scratch for the first time). In case of missing Dynamics NAV permissions, users will be getting error messages saying “You […]

Error: The following ODBC error occurred: [Microsoft][ODBC SQL Server Driver]Database is invalid or cannot be accessed State ID: HY024

I have written how to upload (and why to use Upload function) Dynamics NAV license file already. In the past, I have also have shown how to do this a number of times for consultants, developers and end-users. And once in a while, I would get another question – when I am trying to upload […]