Hi, This is on a clean navision 4.0 database. The database used to have 2 companies set up. We added a new company and did synchronization. Users except super started to have wired permission problems. A permission message for Property Store table pops up when user logins to the database. After click Ok, user is still able to get in. However, the user is not able to open Item card, she get the permission message of Service Invoice Line table which is the table they do not have licensed to. She used to be able to access item card. The user also do not have the permission to run debugger. Any ideas? Thanks a lot. Trin
Hi Trin, Your problem is the license file. Each of the companies has its own license file. You must use the correct license for that company. We had the same problem when trying to use the Cronus Canada Company data. Here is the list of instructions we provided to our users to change the license file: User license information: Navision runs under strict license files. The license dictates which functionality is available to the user. When running Navision for training purposes you must use the Cronus Canada data – and license. To establish this license follow the following steps: 1. Run Navision; 2. Select Tools from the menu at the top of the screen; 3. Select License Info from the drop down menu; 4. Click on the CHANGE button on the bottom of the form; 5. Navigate to: c:local Drive Program Files Microsoft Business Solutions-Navision Client Select cronus.flf and Open 6. A License Screen showing Cronus USA will be displayed; 7. Select File from the menu at top of screen; 8. Select Company 9. Select Cronus Canada 10. You will be returned to Navision – but now with the Cronus License; 11. If the license file screen remains open you can close it now. The above reflects where we loaded the data on our system. You may have to change accordingly. Gary
HI Gary, Thank you so much for your informaiton. I am sorry for the confusion. The 4.0 clean database: I mean a 4.0 without any modification. This is a production database for a client. It is not the NAV 4.0 Demo database. The user starts to have permission messages showing on all companies. Thanks again, Trin
Hi Can you change the license in the DB? If you can do this and run the Service Invoice Line table and delete its contents, my guess is an entry is in here, even if it is a blank line with no data.
Hi Steven, I thought of that just like the contact management permission problem we had in the past. This time, there was no entry on these two tables and I did delete these blank lines just in case. I also did synchronization after the change. It did not work. The problem is that only none super user have this permission errors. Thanks, Yimin
Hello, I think I have the same problem you describe with one customer. We’re running Navision 4.0, SQL. We’ve tried to synchronize security, deleting the users in SQL so they are recreated in the synchronization process but without success. The user is able to login but always receives the message ‘SELECT permision denied for object Property Store’ when opens a company. The only way he doesn’t receive this message is if we give dbowner role in SQL to the user, but this is not a good way to resolve it, so I’d like to know what is happening
quote:
Hi, This is on a clean navision 4.0 database. The database used to have 2 companies set up. We added a new company and did synchronization. Users except super started to have wired permission problems. A permission message for Property Store table pops up when user logins to the database. After click Ok, user is still able to get in. However, the user is not able to open Item card, she get the permission message of Service Invoice Line table which is the table they do not have licensed to. She used to be able to access item card. The user also do not have the permission to run debugger. Any ideas? Thanks a lot. Trin
Originally posted by trin - 2005 Sep 14 : 17:41:24
The Property Store problem is because this table is not included in the ‘All Users’ role. It should be a added there with a read permission, then Synchronize done again on SQL. The other problems sound license related though. Trin, you are saying that the user has a permission error on table ‘Service Invoice Line’ which they do no have license for? If they do not have a license for it, why do expect it can be used? One important difference with 4.0 to previous versions that might be causing this too: Previously a user was able to read from an empty table that they did not have permission to read from. If the table was empty the lack of permissions did not cause an error, Security-wise this is just bad, although convinient for setting up permissions. In 4.0 this was changed - if you want to read a table (weather its c/side, application code or whatever) you need a read permissions, weather its empty or not.