Nope. Those are not configurable options. They're all built into SSMS.
Why on earth would you want to limit copy?
answered Jun 08, 2012 at 04:57 PM
Grant Fritchey ♦♦
Along with what Grant stated, if they can read it in SSMS they are going to be able to copy it out whether it be with a screen capture or copy/paste in certain areas.
IMHO, your security policy should include something that covers data usage and access for your company. You can only physically and logically protect your data so far, once you reach that point your company should have some standard policy that kicks in and does the rest.
I work with a good bit of data with the company I am contracted to and signed an NDA agreement. The wording in that agreement speaks on acknowledging that I am aware of the repercussions that occur if my account is found to have been used to access or leak any information (of any kind) that was not authorized.
Just my $.02
answered Jun 09, 2012 at 05:28 PM
Seriously, a certain level of trust is implied by granting their logins access to the data in the first place. If they are allowed to "see" the data why are they not allowed to work with it?
answered Jun 11, 2012 at 12:21 PM