Thanks Tim, this is very helpfull and indeed very easy!
Peter Van: Dataperf [mailto:dataperf-boun...@dataperfect.nl] Namens Tim Rude Verzonden: maandag 7 augustus 2017 20:23 Aan: dataperf@dataperfect.nl Onderwerp: Re: [Dataperf] user rights / is it possible to avoid deleting by a user Yes, it can be done, and very easily at that. You need to restrict access to the Panel List and only allow users to access panels via a menu. Then for the menu option that goes to the panel, you can select Panel Access Rights of 'Read/Write', 'No Delete', 'Create OK - No Edit/Delete', or 'Read Only'. So in your case, you'd want 'No Delete'. You'll also want to restrict access to the Report List since a user that can access the Report List could create a report that would delete records. So all of the reports you want users to be able to run also need to be put on a menu. I generally add an entry to the main menu to go to the Panel List and then assign a password to it. That way I can get in and make necessary modifications as needed while preventing users from messing things up. Finally, don't forget to protect the database with a Definer password (Shift-F9, 5). Otherwise anyone can hit Alt-F8 from your main menu and do whatever they want. Tim Rude On 8/7/2017 12:34 PM, Peter Boekestijn wrote: Dear fellow DP experts, Is there a way to avoid a user to delete records? Only to create, read, update? I do have some issue with a tax-inspector about our admin processes. He found it not acceptable that every user can simply delete a record. In 35.000 sales invoices he found 11 numbers missing! Any help would be appreciated. Kind regards, Peter Boekestijn _______________________________________________ Dataperf mailing list Dataperf@dataperfect.nl http://lists.dataperfect.nl/cgi-bin/mailman/listinfo/dataperf
_______________________________________________ Dataperf mailing list Dataperf@dataperfect.nl http://lists.dataperfect.nl/cgi-bin/mailman/listinfo/dataperf
