Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
kh_wpl
Starting Member
7 Posts |
 Posted - 2011-10-04 : 11:48:38
|
| I havae installed new sql server instance in my customer computer.he has administration right permistion on her computer.but i want restrict her access to mdf & ldf files.in other means he can stop sql server service from administrative tools on control panel and make a copy of mdf & ldf files.then attach that files and use them. |
|
|
Kristen
Test
22859 Posts |
Posted - 2011-10-04 : 12:06:42
|
| Transparent Data Encryption (TDE) perhaps? |
 |
|
|
kh_wpl
Starting Member
7 Posts |
Posted - 2011-10-04 : 12:18:39
|
| Can you tell me about more?or introduce tutorial |
|
|
|
GilaMonster
Master Smack Fu Yak Hacker
4507 Posts |
Posted - 2011-10-04 : 12:19:30
|
| If he has administrative rights, there is nothing you can do to stop him from doing what he pleases to the database. You can slow him down (which is all TDE would do), but an administrator has full and complete rights to the server and full control over everything on it.--Gail ShawSQL Server MVP |
|
|
|
kh_wpl
Starting Member
7 Posts |
Posted - 2011-10-04 : 12:48:38
|
| Thank's Transparent Data Encryption (DTE) is exactly my solution |
|
|
|
GilaMonster
Master Smack Fu Yak Hacker
4507 Posts |
Posted - 2011-10-04 : 13:35:00
|
| It's not going to stop someone who has administrative access to the server (and SQL) from taking the database files. It will slow them down, it won't stop them.--Gail ShawSQL Server MVP |
|
|
|
|
|
|
how to protect mdf and ldf file on end user host