Quick Query with Application and System Databases

(0) Share

Report

Posted on by street9009

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.