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/04/17 18:49] – conni | dynamiczip:faq:grant_sql_table_rights_faq [2018/10/03 21:00] (current) – 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. | - 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 | + | - 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 Dynamics | + | - Select the system |
- 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.1523990973.txt.gz · Last modified: 2018/04/17 18:49 by conni