970
I created a View under my Company Database in SQL then created a link to in from Excel. How can I give select users rights to update excel spread sheet?
Thanks in advance for any input.
Rick
*This post is locked for comments
Hello Rick
Please let us know if you have any further questions or issues on this subject.
Thank you
One way is to add the view to one of the "RPT" database roles in the company database. You would do this using SQL Server Management Studio.
You'll need to add the user's Windows domain login to SQL Server and then assign that new SQL login to the RPT role mentioned above.
There are other ways to handle this need, though.
Hello Rick,
If you want GP users to be able to use the SQL view, you can give the users or group the SELECT permissions to run the SQL view. Normally with our Dynamics GP views, the DYNGRP is assigned permissions to the view, which lets all GP users access the views when needed via a GP process.
When you say 'give the select users rights to update the excel spreadsheet', what exactly do you mean, as we need more information on what exactly you're looking to do here.
Thanks
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,280
Super User 2024 Season 2
#2
Martin Dráb
230,235
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (