Share
Report
145I am using NAV 2009 SP1 on sql 2008 R2 on standard security model. I have set up role based permissions over the last few months and adding users to these roles a few per week. For some reason all users that log in this afternoon their permissions are not populating from the assigned role. for example i had a user that was able to run a report this morning but she logged out and logged back in about 1 oclock and the permissions do not seem to be there. The permissions error is "you do not have access to RUN the xyz table", now i know this user was able to access this table this morning AND i can see the permission in the role that is assigned to he user. I tested on a user that has been logged in since 8 am this morning had her click on some normal forms and item cards, then i said ok now exit nav and log back in.... the user was restricted from the tables that they just had access 2. i am trying to understand what could be going on, is there a way to see if there is something gummed up in NAV? if i add the super role and then have the user log out and log back in they do not have the permission problem. but if i add the table to any role they receive the error that they do not have permissions to that table... any ideas would be greatly appreciated i am very familiar with the you do not have access to view the xyz table and adding this table to the role but i believe something else is going on here.
When i was digging into this issue (ran a DB compare)i noticed that the role buffer table was dropped for all my companies and the non clustered index on the permissions table $1(unique, Non-Clustered) was missing (WEIRD)
I added the index back in to the system and recreated the tables that were missing. is there ANY way an index and tables can be dropped from NAV?
Like i said some how using super user the users are able to have no problems, the issue is using role based permissions. What could be going on here?
*This post is locked for comments
All responses (
Answers (
