Database master key and symmetric keys protection

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2008 » SQL Server 2008 - General » Database master key and symmetric keys...

Database master key and symmetric keys protection

Rate Topic

Display Mode

Topic Options

Author

Message

sroos

Posted Sunday, November 25, 2012 12:24 PM

SSC-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

Perry Whittle

Posted Monday, November 26, 2012 6:45 AM

SSCertifiable

Group: General Forum Members
Last Login: Today @ 2:33 PM
Points: 5,201, Visits: 11,150

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" Wink

Post #1388586

« Prev Topic | Next Topic »

Permissions