Found my own answer. It's not supported to modify views.
https://support.microsoft.com/en-us/kb/3106512 Daniel Ratliff From: Daniel Ratliff Sent: Tuesday, January 10, 2017 12:09 PM To: [email protected] Subject: Changing permissions on SQL views Just found out the 1610 upgrade wiped some custom permissions we had on v_package in our TEST and QA environments. Is it supported to modify SQL view permissions? If not, should we be settings permissions a different way, on the DB itself instead? If it is, should we open a uservoice request to backup/restore view permissions? Thanks! Daniel Ratliff Technology Architect | Client Innovation Solutions Information Technology Infrastructure (ITI) Humana 123 E. Main St. | Louisville, KY, 40202 T 502.476.9976 [email protected]<mailto:[email protected]> The information transmitted is intended only for the person or entity to which it is addressed and may contain CONFIDENTIAL material. If you receive this material/information in error, please contact the sender and delete or destroy the material/information.
