4 Replies Latest reply on Jun 21, 2017 8:07 AM by mcrip

    Truncate Table requires Full Access

    mcrip

      Filemaker Pro (and Advanced) 15.0.3.305 and 16.0.1.162

      Mac 10.11.6

      Macbook Pro laptop

       

      Description

      Use of the Truncate Table script step appears to require Full Access in order to run.  Attached is an example file.  The Admin account (blank password) can delete all records using any of the 3 buttons (Delete With Show All, Delete with Truncate Current, and Delete with Truncate Selected Table).  Using the guest account or guest_test (also blank password) which use the Data Entry Only and Data Entry Copy privilege sets, you can only delete all the records using the Delete With Show All button.  Both of the Delete With Truncate buttons return an error 9 (insufficient privilege)

       

      How to replicate

      Noted above

       

       

      Workaround (if any)

      If using scripts, the script can be marked as Grant Full Access Privilege