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

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics GP (Archived) / Access Rights for Exce...
Microsoft Dynamics GP (Archived)

Access Rights for Excel Refreshable Reports

(0) ShareShare
ReportReport
Posted on by Irfan Rasheed 550

Hi,

I have created a view in SQL and publish that report it via Excel Report Builder.

Published file get results on my machine, but when other user try to run that report (on their machines). They get message that 'Select permission is denied for XXX tables for XXX user'. I have check that all users are in rpt_XXX database role and all can access GP.

Please advice what part i am missing.

Best Regards.

/Irfan Rasheed || ERP Executive ||  Avanceon Limited

*This post is locked for comments

I have the same question (0)
  • Suggested answer
    Irfan Rasheed Profile Picture
    Irfan Rasheed 550 on at
    Re: Access Rights for Excel Refreshable Reports

    Thanks John,

    Yes, all users have right on the view.

    Thanks Leslie,

    I tried this query in my database. It works fine.

    Infact, I have different scenario. There are two companies in Dynamics.

    I create a view in 1st company (IR_XXX) where table used for both companies say (GL20000).

    I assign access of this view to different database roles in 1st Company. Where database roles, are further assigned to multiple users.

    When I publish report in 1st Company and try to show results to users, they are getting error in excel report that they have no access to Select view of 2nd Company. Whereas said view is not exist there.

    Then I realize that while publishing excel report, there is field of View Name, Which stores that view in 2nd Company SQL Database (XXX). Here I give access of database role to this specific view and then tables.

    It works well for us.

    In your expert opinion, Should I use separate views in both databases or suggest any simple procedure.

    Regards.

    /Irfan

  • L Vail Profile Picture
    L Vail 65,271 on at
    Re: Access Rights for Excel Refreshable Reports

    John,

    Would running the statement:

    GRANT SELECT ON view_name_here TO DYNGRP

    work? That's usually what I do when I'm putting information into Excel.

    Kind regards,

    Leslie

  • Suggested answer
    John Lowther Profile Picture
    John Lowther 5,122 on at
    Re: Access Rights for Excel Refreshable Reports

    Question, did you check the permissions on the view you created?

    Does the rpt_XXX database role have permission to that view?

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

News and Announcements

Join experts in person to explore low code and AI agents at the Power Platform Community Conference sponsored by Microsoft

Quick Links

Responsible AI policies

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

Abhilash Warrier – Community Spotlight

We are honored to recognize Abhilash Warrier as our Community Spotlight honoree for…

Congratulations to the September Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics GP (Archived)

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans