After creating or converting SQL tables and/or stored procedures, rights must be granted to make these tables and/or procedures available to the SQL users. Microsoft Dynamics GP creates and uses a Microsoft SQL Server group DYNGRP to manage table rights. Depending on your setup, all Microsoft Dynamics GP users will automatically be made a member of this group. DynamicZip automatically grants the DYNGRP full rights to DynamicZip tables when they are created. However, on occasion the rights fail to be granted. In these cases, the simplest solution is to run the Grant.sql procedure.
To grant the DynamicZip table rights to DYNGRP:
C:\Program Files (x86)\Microsoft Dynamics\GP2018\SQL\Util
IMPORTANT: This statement needs to be run against each of your company databases as well as your DYNAMICS system database.
Granting permissions to SQL Tables must be completed either by sa or a user with SQL Administrative rights. This procedure will only grant rights to existing tables and stored procedures. You must create the tables before running this procedure. If you drop and recreate the tables, or if you recreate stored procedures, you may need to run this procedure again.