Cool, thanks for the feedback everyone. Daniel Ratliff
From: [email protected] [mailto:[email protected]] On Behalf Of Garth Jones Sent: Tuesday, January 10, 2017 1:55 PM To: [email protected] Subject: [mssms] RE: Changing permissions on SQL views Hi Daniel, So there is an DB roles called smschm_user, which has select rights to "all" views within CM db. I put quote around the "all" because it is only on the views that should be query by reporting. if your view doesn't have this right then there is likely another view that you should be using instead. Of course db_datareader works too. From: [email protected]<mailto:[email protected]> [mailto:[email protected]] On Behalf Of Daniel Ratliff Sent: Tuesday, January 10, 2017 1:34 PM To: [email protected]<mailto:[email protected]> Subject: [mssms] RE: Changing permissions on SQL views 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]> [mailto:[email protected]] On Behalf Of Garth Jones Sent: Tuesday, January 10, 2017 1:15 PM To: [email protected]<mailto:[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. 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.
