Permission

Angelo
Angelo Member Posts: 180
edited 2006-08-09 in NAV/Navision Classic Client
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

Comments

  • johnson_alonso
    johnson_alonso Member Posts: 690
    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
    subscribe to:
    sea-navision-community-subscribe@yahoogroups.com
    detail in:
    http://sea-navision-community.blogspot.com
  • ClausHamann
    ClausHamann Member Posts: 80
    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
    Claus W. Hamann

    http://www.AcumenConsulting.co.nz
  • Angelo
    Angelo Member Posts: 180
    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
    ClausHamann Member Posts: 80
    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
    Claus W. Hamann

    http://www.AcumenConsulting.co.nz
  • Angelo
    Angelo Member Posts: 180
    there is no record in the table because I never used the table and I'm not use BN.

    Regards,
    Angelo
  • Navsyst2
    Navsyst2 Member Posts: 29
    hi,
    do you have more than one company in your database?
  • Angelo
    Angelo Member Posts: 180
    only 1 company......
  • Navsyst2
    Navsyst2 Member Posts: 29
    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)

Categories