Re: Payroll Security
- From: Shaun McDonnell <shaun.mcdonnell@xxxxxxxxx>
- Date: Fri, 28 Apr 2006 13:41:27 +0000 (UTC)
One 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
.
- References:
- Payroll Security
- From: Vensia
- Payroll Security
- Prev by Date: SQL Service password change
- Next by Date: Re: sysxlogins table with <NULL> entries
- Previous by thread: Payroll Security
- Next by thread: SQL Service password change
- Index(es):
