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.
Best Answer
Per the sp_refreshview msdn library page (https://msdn.microsoft.com/en-us/library/ms187821.aspx):