Browse by Tags

All Tags » SQL Server - se... » SQL Server - cryptography   (RSS)
Who needs encryption?
For those that read my previous posts, the question in the title may be startling. I want to reassure you from the start: this post is not about encryption being a useless technique; it is just about it not being a solution for certain problems and definitely Read More...
Posted 30 November 06 06:07 by lcris | 4 Comments   
Filed under , , , ,
SQL Server 2005: An example for how to use counter signatures
A while ago, I wrote a post showing how signatures can be used to allow users to perform operations without explicitly granting them the permissions required for that operation. In this post I'll present more details about the use of signatures. One important Read More...
Posted 19 October 06 06:27 by lcris | 0 Comments   
Filed under , , ,
SQL Server 2005: Example for how to allow a user to encrypt but not decrypt
I've received this question a couple of times before: is it possible to restrict a user to encrypt data, but not be able to decrypt it? The answer to this is yes, but before I present the solution, let's discuss a little how symmetric keys are used. What Read More...
Posted 13 January 06 11:32 by lcris | 9 Comments   
Filed under , , , ,
About security and encryption with references to SQL Server 2005
There have been many books written on security and encryption, and there is much talk about security these days. I will not bring anything new with this post to the general topic of security, but I would like to present some ideas in condensed format. Read More...
Posted 20 December 05 02:06 by lcris | 8 Comments   
Filed under , , , ,
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 , , ,

Search

This Blog

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

Syndication

Page view tracker