question

Roscoe avatar image
Roscoe asked

Copy protect of SQL2012 database

Is there a way (encryption or other utility?) to lockdown an SQL database so it can only be copied for backup purposes and can then only be restored to the same server and location? I want to prevent the ability of a SysAdmin or DBO to schema map and copy/modify an SQL database to use with another company or modify themselves. Thanks Roscoe
copy-databaselocked
10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

1 Answer

·
Fatherjack avatar image
Fatherjack answered
if the person(s) you are concerned about are sysadmin then no, there will be ways that they could access the database. At the end of the day you need to have trusted staff in positions of responsibility. If you are concerned then prevent them having access to the server but even then, a domain admin will be able to access the database and carry out actions that would give them the schema details that you want to protect.
2 comments
10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Roscoe avatar image Roscoe commented ·
Thanks for the reply. If the database is provided to a third party (client) and their DBA has sysadmin rights is there anyway to allow them to manage the database yet protect our IP (schema design) from unauthorised duplication then?
0 Likes 0 ·
Fatherjack avatar image Fatherjack ♦♦ commented ·
only really in legal terms in the contract of taking the software solution from you. If they are an admin then they can bypass any encryption that you use, it would simply be obfuscation, not security.
0 Likes 0 ·

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.