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 [2018/10/03 20:54] connidynamiczip:faq:grant_sql_table_rights_faq [2018/10/03 21:00] (current) conni
Line 10: Line 10:
   - 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 folder. For example: <code>C:\Program Files (x86)\Microsoft Dynamics\GP2018\SQL\Util</code>   - 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 folder. For 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.)   - 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. //
  
 **IMPORTANT:** This statement needs to be run against each of your company databases as well as your DYNAMICS system database. **IMPORTANT:** This statement needs to be run against each of your company databases as well as your DYNAMICS system database.
dynamiczip/faq/grant_sql_table_rights_faq.txt · Last modified: 2018/10/03 21:00 by conni

Donate Powered by PHP Valid HTML5 Valid CSS Driven by DokuWiki