Re: Confidential data
news_at_news.com
Date: 05/14/03
- Next message: SriSamp: "Re: Define column as nchar (unicode) to store encrypted data?"
- Previous message: Mary Chipman: "Re: norstrom secure page to charge"
- In reply to: Tom Moreau: "Re: Confidential data"
- Next in thread: Tom Moreau: "Re: Confidential data"
- Reply: Tom Moreau: "Re: Confidential data"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
Date: Tue, 13 May 2003 17:21:48 -0700
including the backups!
"Tom Moreau" <tom@dont.spam.me.cips.ca> wrote in message news:eywcpwVGDHA.2176@TK2MSFTNGP10.phx.gbl...
If you have Windows 2000, consider using Encrypted File System (EFS) on the SQL Server files.
--
Tom
---------------------------------------------------------------
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
SQL Server MVP
Columnist, SQL Server Professional
Toronto, ON Canada tom@cips.ca
www.pinnaclepublishing.com/sql
"Krygim" <krygim@hotmail.com> wrote in message news:uJKgeqVGDHA.2068@TK2MSFTNGP10.phx.gbl...
I am a director of our company. In order to store the confidential payroll
data, I have installed a separate instance of SQL server for the data.
However I can't find any way to block our network system administrator's
access to the payroll MDF file. Even if I have set the authentication mode
to SQL server and deny BUILTIN\Administrator's access to the SQL instance, I
find that the network administrator can always copy and attached the MDF
file to another SQL server to view the data inside.
Can anybody advice the proper way to keep the payroll data confidential?
Thanks in advance.
- Next message: SriSamp: "Re: Define column as nchar (unicode) to store encrypted data?"
- Previous message: Mary Chipman: "Re: norstrom secure page to charge"
- In reply to: Tom Moreau: "Re: Confidential data"
- Next in thread: Tom Moreau: "Re: Confidential data"
- Reply: Tom Moreau: "Re: Confidential data"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
Relevant Pages
|