Comments
1 comment
-
Hello,
SQL Prompt may need VIEW SERVER STATE in order to decrypt encrypted objects. Please see our knowledge base for more information:
http://www.red-gate.com/supportcenter/C ... 000105.htm
Add comment
Please sign in to leave a comment.
I'm curious why a user needs VIEW SERVER STATUS permissions for SQL Prompt to work?
I have a user that's dbo on his database, but gets an error during SQL Prompt Caching the data for his database while "Reading Permissions".
What exactly is SQL Prompt reading from the dynamic tables to need a server level permission?
Thanks,
Patrick