Re: Confidential data

news_at_news.com
Date: 05/14/03


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.



Relevant Pages

  • Re: Confidential data
    ... consider using Encrypted File System on the SQL Server files. ... In order to store the confidential payroll ... access to the payroll MDF file. ...
    (microsoft.public.sqlserver.security)
  • Re: Confidential data
    ... True, but in SQL Server 2000, you can password-protect the backups but I'd go for the belt-and-suspenders approach of doing both. ... In order to store the confidential payroll ... access to the payroll MDF file. ...
    (microsoft.public.sqlserver.security)
  • Confidential data
    ... In order to store the confidential payroll ... I have installed a separate instance of SQL server for the data. ... access to the payroll MDF file. ...
    (microsoft.public.sqlserver.security)

Quantcast