You’re offline. This is a read only version of the page.
Announcements
120
Hello,
I created a custom view (with the intent of using for a QQ) that accesses both the System and Application databases (it pulls mostly from Application but also pulls one column from System). System administrators can query from the view just fine, but normal users cannot. They get a "The server principal (username) is not able to access the database "System" under the current security context." error (Error 916). Microsoft posted an article that said views of this nature would have to be converted to stored procedures, but I don't think QQ's can be based on stored procedures, can they?
How can I make this work?
Thanks for any advice anyone has.
*This post is locked for comments
#1
André Arnaud de Cal...
291,359
Super User 2024 Season 2
#2
Martin Dráb
230,370
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (