Raul Garcia's blog
Popularity Report
 |
|||
|
|||
|
|||
|
|||
|
|||
|
Rank
URL Tag Cloud
Bookmark History
Saved by 1 people (0 private), first by anonymouse user on 2006-08-27
- Yyensen on 2006-08-27 - Tags developer , encryption , searching , sql_server , sql_server_2005 , tech
Public Sticky notes
Index a MAC of your data
We can use a MAC (Message Authentication Code) of the plaintext to create a new indexing column. This approach is similar to using a hash, but it requires a secret key to calculate the MAC. This prevents an unauthorized user to use a general purpose dictionary of hashed values and it will also prevent her from creating a targeted dictionary without having access to the MAC key. Please note that an attacker who has access to the MAC key can generate a targeted dictionary.
SQL Server 2005 doesn’t provide a function for computing a MAC, but it is possible to write a user-defined function that calculates a MAC using either SQL Server 2005 CLR or by reusing the existing builtin functions.
Highlighted by yyensen
Public Comment
on 2006-08-27 by yyensen