VIEW SERVER STATUS Permission?
pburleson
Posts: 12
Hello,
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
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
Comments
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