0

I need to give a user the required permission to run sp_refreshview for a specific database on our server. I've tried adding the user to the db_executor role but that only gave them access to certain stored procedures.

Am I looking to accomplish something that is impossible for SQL Server permissions or am I just looking in the wrong places? Thank you in advance for any guidance you can provide.

Improve this question

1 Answer 1

Reset to default
1

Per the sp_refreshview msdn library page (https://msdn.microsoft.com/en-us/library/ms187821.aspx):

Permissions Requires ALTER permission on the view and REFERENCES permission on common language runtime (CLR) user-defined types and XML schema collections that are referenced by the view columns.

Improve this answer
1
  • Thank you for the helpful reply MguerraTorres. This does tell me what permissions I need to accomplish this task. However, I cannot seem to add REFERENCES for the XML Schema Collections. I receive an error that the privilege is not compatible with the object.
    – Ben Bloodworth
    Commented Jul 27, 2016 at 17:04

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.