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 |
|
ravilobo
Master Smack Fu Yak Hacker
1184 Posts |
 Posted - 2008-08-13 : 16:37:47
|
| We are hosting a client’s data on our server. The client doesn’t want us to view the data, though we have sys admin access. How ever we should be able to do DDL. Is this possible in SQL2K5? ------------------------I think, therefore I am - Rene Descartes |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-08-13 : 16:40:36
|
| What do you mean? We also have client data which they say we are not allowed to view? but how can you prevent sysadmin from it? |
 |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2008-08-13 : 16:41:55
|
quote:
Originally posted by sodeep
What do you mean? We also have client data which they say we are not allowed to view? but how can you prevent sysadmin from it?
It's simple. They need to protect their data from us by encrypting it. Otherwise, we can see it.Tara KizerMicrosoft MVP for Windows Server System - SQL Serverhttp://weblogs.sqlteam.com/tarad/Subscribe to my blog |
|
|
|
ravilobo
Master Smack Fu Yak Hacker
1184 Posts |
Posted - 2008-08-13 : 17:04:56
|
quote:
Originally posted by tkizerThey need to encrypt their data.
Is it something easily achievable?------------------------I think, therefore I am - Rene Descartes |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
ravilobo
Master Smack Fu Yak Hacker
1184 Posts |
Posted - 2008-08-13 : 17:17:01
|
| Can we encrypt from sql server or need some third party tool?------------------------I think, therefore I am - Rene Descartes |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
Michael Valentine Jones
Yak DBA Kernel (pronounced Colonel)
7020 Posts |
Posted - 2008-08-13 : 18:21:00
|
| You could take away your sysadmin access, and let the client manage the server.CODO ERGO SUM |
|
|
|
|
|
|
Data restriction