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
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
Question, did you check the permissions on the view you created?
Does the rpt_XXX database role have permission to that view?
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,214
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (