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