Payroll Database Security

Dear all,
I have a payroll database and only payroll user can see the data. Can I
prevent the SQL server administrator accessing the database ?
Thanks before.
Regards,
VensiaHi
No, not natively. Get your vendor to support SQL Server 2005 when it is
released 7 November 2005 and then each column can be encrypted in the DB.
--
--
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"Vensia" wrote:

> Dear all,
> I have a payroll database and only payroll user can see the data. Can I
> prevent the SQL server administrator accessing the database ?
> Thanks before.
> Regards,
> Vensia
>
>|||Currently, how payroll software vendor protect the database from being
accessed by administrator except the HR user ?
Thx.
"Mike Epprecht (SQL MVP)" <mike@.epprecht.net> wrote in message
news:FCB592B0-6112-4567-8B01-EB7DA1150331@.microsoft.com...[vbcol=seagreen]
> Hi
> No, not natively. Get your vendor to support SQL Server 2005 when it is
> released 7 November 2005 and then each column can be encrypted in the DB.
> --
> --
> Mike Epprecht, Microsoft SQL Server MVP
> Zurich, Switzerland
> MVP Program: http://www.microsoft.com/mvp
> Blog: http://www.msmvps.com/epprecht/
>
> "Vensia" wrote:
>