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
Author
Message
Posted Sunday, November 25, 2012 12:24 PM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

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?

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


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Today @ 4:26 AM
Points: 6,466, Visits: 13,922
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