Permission

Angelo

Hello master,

I have a problem when opening company in Navision. When I open Navision and press F12(for opening company), there is error message said : you dont have permission to access Property store table. So, I give the permission to the user for the table and try to open navision again,but the error still exist. What should I do with the problem?What is Property Store table used for? I never play with Property Store table.

Regards,
Angelo

johnson_alonso

where did you install the database? in SQL or in navision database server..?
I check in all manuals pdf, nothing relate to ur problems. :-k

ClausHamann

Hi Angelo

The “Property Store” table is used in Business Notifications.

I assume there is at least one record in the table since you get a permission error. If you don’t use Business Notifications then your issue will be solved when the records in the table are deleted. The issue with this is that you probably won’t be able to do so (as your users get a permission error). You will need to get you Navision solution center to delete the records if you can't do it your self.

Regards

Claus

Angelo

this is strange error.when I see the backend(Microsoft SQL),the user not dbo.when I checked as dbo,the error can be solved.Anyway,thx for answering my question and give advices.

thx,
Angelo

ClausHamann

Hi Angelo

Was there any records in the table, did you delete them if there were or did you solve the issue by giving the user dbo permission?

Regards

Claus

Angelo

there is no record in the table because I never used the table and I'm not use BN.

Regards,
Angelo

Navsyst2

hi,
do you have more than one company in your database?

Angelo

only 1 company......

Navsyst2

Another way ist deactivate the code that access the table. (if you didn't use the table).

there are also many suggestions in this forum about role syncronization (only for SQL)