Prev: Sorting "both" ways?
Next: add an aggregate to a SELECT
From: John Grant on 26 Jun 2008 19:04
How do you encrypt data in SQL 2005 so the DBA or SQL Server adminstratior
can't decrypt? I don't see an easy way, but I found a blog that indicated it
may be possible.

thanks
-John
From: John Bell on 27 Jun 2008 02:55

"John Grant" <JohnGrant(a)discussions.microsoft.com> wrote in message
news:11C07388-2C55-4B15-BA41-4AF2E2A88EDC(a)microsoft.com...
> How do you encrypt data in SQL 2005 so the DBA or SQL Server adminstratior
> can't decrypt? I don't see an easy way, but I found a blog that indicated
> it
> may be possible.
>
> thanks
> -John

Hi John

Stopping a determined System Admin Accessing data encrypted or not in SQL
2005 is not possible, which is one reason to restrict permissions and
keeping them to the minimum a user requires. You may want to read
http://blogs.msdn.com/lcris/archive/2006/11/30/who-needs-encryption.aspx

John

 | 
Pages: 1
Prev: Sorting "both" ways?
Next: add an aggregate to a SELECT