Payroll Security

Dear all,
I want to use SQL 2005 as back end for payroll software.
If I want the administrator can not see the employee salary, how to use the
built in encryption feature ?
Thanks.
VensiaOne of the ways to do this would to use a trigger on the table that contains
the information. In this CLR Trigger, call the native encryption functions.
Shaun McDonnell

> Dear all,
> I want to use SQL 2005 as back end for payroll software.
> If I want the administrator can not see the employee salary, how to
> use the
> built in encryption feature ?
> Thanks.
> Vensia
>