disable right click

is there a way to disable right click or copy/paste and export options in SSMS

Thank You

more ▼

asked Jun 08, 2012 at 04:31 PM in Default

avatar image

388 27 33 37

(comments are locked)
10|1200 characters needed characters left

3 answers: sort voted first

Nope. Those are not configurable options. They're all built into SSMS.

Why on earth would you want to limit copy?

more ▼

answered Jun 08, 2012 at 04:57 PM

avatar image

Grant Fritchey ♦♦
137k 20 47 81

I dont want users to copy data or export it (for security reasons ) ... all I want them to do is query it and look at it

Jun 08, 2012 at 06:47 PM IT1

If they can get the data onto their screen,using any tool, they can copy and/or export that data using some mechanism. You can' expose information and hide it or control it at the same time.

Jun 11, 2012 at 12:09 PM Grant Fritchey ♦♦
(comments are locked)
10|1200 characters needed characters left

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

more ▼

answered Jun 09, 2012 at 05:28 PM

avatar image

6.6k 21 26 34

(comments are locked)
10|1200 characters needed characters left
  • Set up a computer in a monitored room.

  • Remove any removable drives.

  • Configure firewalls so that the only network connectivity the system has is to SQL Server.

  • Revoke users' rights from SQL Server

  • Create new logins for access via this new mechanism

  • Take a ruler to their knuckles if they try and copy anything to paper.

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?

more ▼

answered Jun 11, 2012 at 12:21 PM

avatar image

12.1k 30 36 42

Great. I really enjoyed it ;) I wish I could give more than +1.

Jun 11, 2012 at 12:25 PM Usman Butt
(comments are locked)
10|1200 characters needed characters left
Your answer
toggle preview:

Up to 2 attachments (including images) can be used with a maximum of 524.3 kB each and 1.0 MB total.

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here



Answers and Comments

SQL Server Central

Need long-form SQL discussion? SQLserverCentral.com is the place.



asked: Jun 08, 2012 at 04:31 PM

Seen: 1147 times

Last Updated: Jun 11, 2012 at 12:25 PM

Copyright 2018 Redgate Software. Privacy Policy