Differences

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

--- dynamiczip:faq:grant_sql_table_rights_faq [2018/04/17 20:51] – chuck
+++ dynamiczip:faq:grant_sql_table_rights_faq [2018/10/03 21:00] (current) – conni
@@ Line 9: / Line 9: @@
   - 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.
   - 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 Dynamics database from the database (DB) list.
+  - 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.
   - Select any company database from the DB list. For example, select TWO.
   - 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.