User Tools

Site Tools


dynamiczip:faq:grant_sql_table_rights_faq

Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Both sides previous revisionPrevious revision
Next revision
Previous revision
dynamiczip:faq:grant_sql_table_rights_faq [2015/05/22 16:58] connidynamiczip:faq:grant_sql_table_rights_faq [2018/10/03 21:00] (current) 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. 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 "DYNGRPto manage table rights. Depending on your setup, all Microsoft Dynamics GP users can automatically be made a member of this group. +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 =====
  
 **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 >> Microsoft SQL Server >> Query Analyzer.  +  - Open the SQL Server Management Studio. The icon should be included in the Microsoft SQL Server Group. Start » Apps » Microsoft SQL Server » SQL Server Management Studio.  
-  - 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. +  - Select File > Open > File and browse to the file named Grant.sql. This file can be found in the SQL\UTIL folder inside the Dynamics GP installation folderFor example: <code>C:\Program Files (x86)\Microsoft Dynamics\GP2018\SQL\Util</code> 
 +  - Select the system database from the database (DB) list. (The default name for the system database is DYNAMICS.)
   - 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. 
   - Select any company database from the DB list. For example, select TWO.    - Select any company database from the DB list. For example, select TWO. 
   - Click Execute Query to run the script for the selected database.    - Click Execute Query to run the script for the selected database. 
-  - //Repeat steps 5 and 6 for all company databases. //+  - //Repeat steps 5 and 6 for all company databases making sure to click Execute Query for each 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 will need to run this procedure again.+**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.
  
-[[dynamiczip:faq:Frequently Asked Questions]] +----
  
-\\ +[[dynamiczip:faq:Frequently Asked Questions]] \\ 
 +[[dynamiczip:troubleshooting:Troubleshooting]] 
  
dynamiczip/faq/grant_sql_table_rights_faq.1432313887.txt.gz · Last modified: 2015/05/22 16:58 by conni

Donate Powered by PHP Valid HTML5 Valid CSS Driven by DokuWiki