You’re offline. This is a read only version of the page.
I've created a report for a client using a custom view in the application database. I put the report and view on their server, ran Database Maintenance to sync ownership, and added it to Screens and Report Control Maintenance. One user (out of three) can run the report with no issues. The two other users receive the following error:
I have checked the permissions on the view and they look fine. The only group that the good user belongs to that the others don't is the Administrators group; I temporarily added one of the faulting users to that group to test, but it made no difference. I've deleted the ODBC connection for both the app and system databases and recreated them by running another report.
Any suggestions? Thanks in advance.
Stuart Nottingham
No, I was actually referring to the SQL Management Studio. I had given the same permissions to those same "users" in the properties window of the view.
OK this did the trick! Can you explain why this would work and granting the same rights/privileges through the GUI wouldn't?
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,253
Super User 2024 Season 2
#2
Martin Dráb
230,188
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (