Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
Log in  ::  Register  ::  Not logged in
Home       Members    Calendar    Who's On

Add to briefcase

Database master key and symmetric keys protection Expand / Collapse
Posted Sunday, November 25, 2012 12:24 PM


Group: General Forum Members
Last Login: Saturday, January 26, 2013 2:59 AM
Points: 199, Visits: 240
Hi guys,

A quick question about encryption:

What is the reason why the database master key can not protect symmetric keys directly as it can protect the private keys of asymmetric keys and certificates?

Post #1388416
Posted Monday, November 26, 2012 6:45 AM



Group: General Forum Members
Last Login: Today @ 4:58 AM
Points: 7,789, Visits: 15,837
The database master key is itself a symmetric key. Assymetric keys provide increased security, the symmetric key is purely used to protect the main (or Assymetric key) while it is stored on the server.

Have a read through the encryption hierarchy in Bok Online at this link.


"Ya can't make an omelette without breaking just a few eggs"
Post #1388586
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse