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 revisionNext revisionBoth sides next revision | ||
dynamiczip:faq:grant_sql_table_rights_faq [2018/04/17 18:47] – conni | dynamiczip:faq:grant_sql_table_rights_faq [2018/10/03 20:54] – 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. This statement needs to be run against each of your company databases as well as your DYNAMICS system database.// | + | - //Repeat steps 5 and 6 for all company databases. |
+ | |||
+ | **IMPORTANT: | ||
Granting permissions to SQL Tables must be completed either by sa or a user with SQL Administrative rights. This procedure will only grant rights to existing tables and stored procedures. You must create the tables before running this procedure. If you drop and recreate the tables, or if you recreate stored procedures, you may need to run this procedure again. | Granting permissions to SQL Tables must be completed either by sa or a user with SQL Administrative rights. This procedure will only grant rights to existing tables and stored procedures. You must create the tables before running this procedure. If you drop and recreate the tables, or if you recreate stored procedures, you may need to run this procedure again. |
dynamiczip/faq/grant_sql_table_rights_faq.txt · Last modified: 2018/10/03 21:00 by conni