User Tools

Site Tools


dynamiczip:faq:grant_sql_table_rights_faq

This is an old revision of the document!


How do I grant SQL table rights?

NOTE: Effective with Build 68 you no longer need to grant rights to DYNGRP, this process happens automatically the first time sa logs in. Failure to log in as sa will result in some DynamicZip functions being disabled.

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. When new tables are created, Microsoft» SQL does not automatically grant access rights to anyone except the user who created the tables. Before any other user can access the new tables, access rights must be granted to them. Microsoft Dynamics GP (Great Plains) creates and uses a Microsoft SQL Server group “DYNGRP” to manage table rights. Depending on your setup, all Microsoft Dynamics GP users can automatically be made a member of this group.

To grant the DynamicZip table rights to DYNGRP:

  1. Open the SQL Query Analyzer. The icon should be included in the Microsoft SQL Server Group. Start » Programs » Microsoft SQL Server » Query Analyzer.
  2. Choose File » Open to open the file named Grant.sql. This file can be found in the UTIL folder where the Server components are installed. Select the Dynamics database from the database (DB) list.
  3. Click Execute Query to run the script for the selected database. A message in the lower part of the window will let you know it was completed successfully.
  4. Select any company database from the DB list. For example, select TWO.
  5. Click Execute Query to run the script for the selected database.
  6. Repeat steps 5 and 6 for all company databases.

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 will need to run this procedure again.


Frequently Asked Questions


dynamiczip/faq/grant_sql_table_rights_faq.1425582308.txt.gz · Last modified: 2015/05/22 16:58 (external edit)

Donate Powered by PHP Valid HTML5 Valid CSS Driven by DokuWiki