June 2005 - Posts

SQL Server 2005: procedure signing demo
The ability to sign procedures is my favorite cryptographic feature in SQL Server 2005. If we want to write a procedure that requires permission P, and we want Alice to be able to execute the procedure but we do not want to grant her the permission P, Read More...
Posted 15 June 05 09:23 by lcris | 6 Comments   
Filed under , , ,
SQL Server 2005: column encryption demo part 2
I modified the last column encryption demo by protecting the encryption key with a certificate instead of using a password. The advantage to this approach is that a password is no longer needed when opening the key. The advantage of the password approach Read More...
Posted 10 June 05 07:53 by lcris | 12 Comments   
Filed under , , ,
SQL Server 2005 helpful catalogs: crypt_properties and key_encryptions
A while ago, I answered a question about how to find out what keys are encrypted by a certificate. Since then, I compiled a list of useful queries that can be used to find out the encryptions and signatures made with a cryptographic entity. Before listing Read More...
Posted 10 June 05 03:44 by lcris | 0 Comments   
Filed under ,
Simple demo for how to encrypt and decrypt a table column in SQL Server 2005
For my first post, I decided to make available a very simple demo I wrote recently to demonstrate how data can be encrypted in SQL Server 2005. You can paste the following script in SSMS and execute it line by line while following the comments. The script Read More...
Posted 09 June 05 08:29 by lcris | 2 Comments   
Filed under , , ,

Search

This Blog

These posts are provided "AS IS" with no warranties, and confer no rights.

Syndication

Page view tracker