Hi, This might sound as a weird problem, please bear with me. I have a customer who likes to duplicate his company data now and then to have a playground for his users for experiments and training purpose. Once in a while they call me to run a report which just copies the production data in the test company to refresh their test environement after they have messed it up. I would like to get rid of this annoyance by enabling them to run the report by themselves, whenever they like, but their license obviously doesn’t allow them to write on most of the involved tables. Is there a way I can give the report writing permissions to all tables without spending the rest of my life on the task? [B)] Thanks Anna
Hello Anna, If you are a solution developer (Or have a colleague who is), you can add the necessary permissions to the report: Design the report in the object designer → In the Data Item screen go to the first blank line under the listed data items → Go → View → Properties Add the permissions for the “protected” tables in the “Permissions” property. Hope this is of help!
Why not do a backup and restore of the company?
I agree with you jack, why should backup and restore not work? after they mess with the data, delete the company since navision won’t allow 2 companies with the same name (you can just rename it if the license allows it)and then restore your backup 
Jack and Robert are right…that would be the simplest solution… It would also teach them the importance of backups & how to do them [:D]
quote:
Originally posted by EBloom
Hello Anna, If you are a solution developer (Or have a colleague who is), you can add the necessary permissions to the report: Design the report in the object designer → In the Data Item screen go to the first blank line under the listed data items → Go → View → Properties Add the permissions for the “protected” tables in the “Permissions” property. Hope this is of help!
I had started to do so, but have you any idea about how many tables are involved? And when you have reached the bottom of the “permissions” form, you have to insert the new record using F3 or a sequence of tabs, then type the next table number or search it in the search form which, of course, will start every time from the first one. Then try to run the report and discover after some hours that you forgot a table. [}:)] That’s why I was looking around for some smart trick. If there is none … shrug! [V] BTW - I’m not going to tell a user, as smart as he might be, “Delete your production company, then restore it”, That’s looking for big trouble! [:p] Anna
Hi, I solved the problem in starting 2 servers : - Production - Playyard every night the system closes both server for backup to tape. after that i copy the production files to the Playyard server Starting both server and all is done. BUT : I can use two different machines, else the simple copying of files will not work!
Sorry, shurely there is some installation work in HOSTS, SERVICES and so on, but in the end it works
quote:
Originally posted by iammicky
Sorry, shurely there is some installation work in HOSTS, SERVICES and so on, but in the end it works
That would be the least, having two machines to work with. [:D] One might try to give the suggestion anyway, who knows? Thank you all, boys Anna
In my case it was a naturally way, because there were 1 PDC (Primary Domain Controller) 2 BDC (Backup Domain Controller) 1 Navision-Server, so i choose one of the BDC’s as Navision-Backupserver
Will creating two companies not work? one is for the actual company and the other is for the practice company. the customer’s license is allowed to create another company if it has “CRONUS” in the first part of the name right?
quote:
Originally posted by bobby_ph
Will creating two companies not work? one is for the actual company and the other is for the practice company. the customer’s license is allowed to create another company if it has “CRONUS” in the first part of the name right?
Right, but my problem is to copy data from company A to company B, using a report built on Objects table which reads data from company A and writes then into company B. If the report is run with a customer’s license it crashes on the first reserved table. I know I can give write permission for each table, but I can’t do it by hand … well maybe I can, but I’m not sure my lifetime will be long enough. [}:)] Anna
Hi Anna, which way you are going ?