web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics GP (Archived) / SQL View Permissions
Microsoft Dynamics GP (Archived)

SQL View Permissions

(0) ShareShare
ReportReport
Posted on by Rick13 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

I have the same question (0)
  • Derek Albaugh Profile Picture
    Derek Albaugh on at

    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

  • callen Profile Picture
    callen 4,595 on at

    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.

  • Derek Albaugh Profile Picture
    Derek Albaugh on at

    Hello Rick

    Please let us know if you have any further questions or issues on this subject.

    Thank you

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics GP (Archived)

#1
Community Member Profile Picture

Community Member 2

#2
mtabor Profile Picture

mtabor 1

#2
Victoria Yudin Profile Picture

Victoria Yudin 1

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans