Yeah it's not supported to modify views. that said... We have some custom views, too. Prior to any patch or upgrade we save the views (right-click, script-view as, create to, editor window; save it); and then just re-create the view once the upgrade is complete.
Not supported doesn't mean it "won't work". Just that you accept the risk of doing that; and know exactly what you are doing, why, and how to undo your customizations if necessary. On Tue, Jan 10, 2017 at 12:34 PM, Daniel Ratliff <[email protected]> wrote: > Just granting a service account view rights. > > > > The justification is that they didn’t want to grant rights to the entire > DB, just this one view. > > > > *Daniel Ratliff* > > > > *From:* [email protected] [mailto:listsadmin@lists. > myitforum.com] *On Behalf Of *Garth Jones > *Sent:* Tuesday, January 10, 2017 1:15 PM > *To:* [email protected] > *Subject:* [mssms] RE: Changing permissions on SQL views > > > > What are you trying to do? Most of the views already have a db role that > will allow you to select from the view. > > > > > > > > *From:* [email protected] [mailto:listsadmin@lists. > myitforum.com <[email protected]>] *On Behalf Of *Daniel > Ratliff > *Sent:* Tuesday, January 10, 2017 12:09 PM > *To:* [email protected] > *Subject:* [mssms] 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 <(502)%20476-9976> > > [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. > > > > > > 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. > > -- Thank you, Sherry Kissinger My Parameters: Standardize. Simplify. Automate Blogs: http://www.mofmaster.com, http://mnscug.org/blogs/sherry-kissinger, http://www.smguru.org
