dynamiczip:faq:grant_sql_table_rights_faq
Differences
This shows you the differences between two versions of the page.
| Both sides previous revisionPrevious revision | Last revisionBoth sides next revision | ||
| dynamiczip:faq:grant_sql_table_rights_faq [2018/10/03 20:54] – conni | dynamiczip:faq:grant_sql_table_rights_faq [2018/10/03 20:55] – 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: < | - 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: < | ||
| - 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. // | ||
dynamiczip/faq/grant_sql_table_rights_faq.txt · Last modified: 2018/10/03 21:00 by conni