Differences

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

--- dynamiczip:faq:grant_sql_table_rights_faq [2018/04/17 18:49] – conni
+++ dynamiczip:faq:grant_sql_table_rights_faq [2018/10/03 20:55] – conni
@@ Line 8: / Line 8: @@
   - 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 Microsoft Dynamics\GP2018\SQL\Util and select Grant.sql. 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 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.