I did some work for a client recently which involved creating a report which could be run against any database; we therefore needed to add the user to a database role in all databases which gave access to the relevant SQL objects.
The below script generates a SQL script which can be used to alter the role to assign it to the specified user in all of the Microsoft Dynamics GP company…
Continue Reading azurecurve’s Article on their blog
Assign a Microsoft SQL Server Role to a User in All Microsoft Dynamics GP Databases
I did some work for a client recently which involved creating a report which could be run against any database; we therefore needed to add the user to a database role in all databases which gave access to the relevant SQL objects.
Blog Syndicated with azurecurve’s Permission
More About This Author
Array
- Dyn365GP6 May 2024New Functionality In Microsoft Dynamics 365 Business Central 2024 Wave 1: Ensure Accurate Inventory Valuation by Controlling Cost Adjustment
- Dyn365GP3 May 2024New Functionality In Microsoft Dynamics 365 Business Central 2024 Wave 1: See Improved Usability for Warehouse and Inventory
- Dyn365GP3 May 2024New Functionality In Microsoft Dynamics 365 Business Central 2024 Wave 1: Automate the Reminders Process in Collections
- Dyn365GP2 May 2024New Functionality In Microsoft Dynamics 365 Business Central 2024 Wave 1: Allow Lines with Amounts of Zero on Recurring General Journals