Read Permission problems - anyone encounter same prob as me?

roland

Hi all,

Just would like to find out if anyone have encountered the same problem as my customer.

My customer is running Navision Attain 3.01B on MS-SQL Server with their own license file. In certain parts of the app (finsql.exe), for example, Job Journal, when they key in the Item No., the system will give them an error "You do not have read permission to the Item Price table", even with a SUPER user role. Same goes for when entering Quantity in the Job Journal, the error "You do not have read permission to the Requisition Line table" appears.

At first I thought that their license file do not have the necessary granules, but when I restored their data into local Navision fdb database, I do not get any errors with the same license and same user roles.

I have asked MBS to check it out, but I am curious if anyone else have encountered similiar problems :?:

Have a nice day!


Roland

jsrark

Have you checked the user permissions.

roland

Hi! Yes I did, I am using a SUPER user role for both finsql.exe and fin.exe

DenSter

That is a role assigned to a user. Just because the text in the role says 'this role has all permissions' does not mean that it actually does. Go to Tools->Security->Roles, which opens the roles window, then select the SUPER role and select 'permissions' from the role button. In the following form, it should ONLY have zeros in the object ID field. If it doesn't then this role only has permissions for the ones that are specifically assigned.

Once you assign one permission for a certain object ID, Navision takes away all permissions for all other objects of the same type.

rutairat

i've seen the similar problem like u, but i found in navision 3.7 TH. I found that the client licence can't work with customer ledger entry and vender ledger entry even they have a license permission. But if i use developer licence, it can do. :shock:

i send this error to support, they accept this error. Maybe, u should contact with your navision support.

max

Go into the object designer and run mentioned table. If you can run it with the customer license, it is a permission issue else it is a license issue