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:[email protected]] 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:[email protected]> [mailto:[email protected]] On Behalf Of Daniel Ratliff Sent: Tuesday, January 10, 2017 12:09 PM To: [email protected]<mailto:[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 [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. 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.
