dynamiczip:faq:grant_sql_table_rights_faq
Differences
This shows you the differences between two versions of the page.
Both sides previous revisionPrevious revisionNext revision | Previous revisionNext revisionBoth sides next revision | ||
dynamiczip:faq:grant_sql_table_rights_faq [2017/02/24 21:32] – [Running Grant.sql] chuck | dynamiczip:faq:grant_sql_table_rights_faq [2018/04/17 18:46] – conni | ||
---|---|---|---|
Line 1: | Line 1: | ||
====== How do I grant SQL table rights? ====== | ====== How do I grant SQL table rights? ====== | ||
- | 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 (Great Plains) | + | 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. |
===== Running Grant.sql ===== | ===== Running Grant.sql ===== | ||
Line 7: | Line 7: | ||
**To grant the DynamicZip table rights to DYNGRP: ** | **To grant the DynamicZip table rights to DYNGRP: ** | ||
- | - Open the SQL Query Analyzer. The icon should be included in the Microsoft SQL Server Group. Start >> Programs >> | + | - Open the SQL Server Management Studio. The icon should be included in the Microsoft SQL Server Group. Start » Apps » Microsoft SQL Server |
- | - Choose | + | - Select |
- Select the Dynamics database from the database (DB) list. | - Select the Dynamics database from the database (DB) list. | ||
- 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. | - 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. | ||
Line 19: | Line 19: | ||
---- | ---- | ||
- | [[dynamiczip: | + | [[dynamiczip: |
- | + | [[dynamiczip: | |
- | \\ | + | |
dynamiczip/faq/grant_sql_table_rights_faq.txt · Last modified: 2018/10/03 21:00 by conni