Online Documentation for SQL Manager for SQL server
In SQL Server 2005 and higher, data can be encrypted with a hierarchical encryption and key management infrastructure. Each layer encrypts the layer below it by using a combination of the following mechanisms for encryption: symmetric keys, asymmetric keys, certificates.
A Certificate is a digitally-signed statement that binds the value of a public key to the identity of the person, device or service that holds the corresponding private key. Certificates are database-level securable objects that follow the X.509 standard and support X.509 V1 fields. A certificate can be loaded from a file or assembly upon its creation.
Certificate Editor allows you to define certificate properties. It opens automatically when you create a new certificate and is available on editing an existing one.
To open a certificate in Certificate Editor, double-click it in the DB Explorer tree.
- Using Navigation bar and Toolbar
- Creating/editing certificate
- Backup Certificate dialog
- Browsing object dependencies
- Viewing DDL definition
- Setting object permissions