Section courante

A propos

Section administrative du site

CREATE CERTIFICATE

Crée un certificat
  Microsoft SQL Server

Syntaxe

CREATE CERTIFICATE certificate_name [ AUTHORIZATION user_name ]
{ FROM existing_keys | generate_new_keys }
[ ACTIVE FOR BEGIN_DIALOG = { ON | OFF } ]

existing_keys ::=
ASSEMBLY assembly_name
| {
[ EXECUTABLE ] FILE = 'path_to_file'
[ WITH PRIVATE KEY ( private_key_options ) ]
}
| {
BINARY = asn_encoded_certificate
[ WITH PRIVATE KEY ( private_key_options ) ]
}
generate_new_keys ::=
[ ENCRYPTION BY PASSWORD = 'password' ]
WITH SUBJECT = 'certificate_subject_name'
[ , date_options [ ,...n ] ]

private_key_options ::=
{
FILE = 'path_to_private_key'
[ , DECRYPTION BY PASSWORD = 'password' ]
[ , ENCRYPTION BY PASSWORD = 'password' ]
}
|
{
BINARY = private_key_bits
[ , DECRYPTION BY PASSWORD = 'password' ]
[ , ENCRYPTION BY PASSWORD = 'password' ]
}

date_options ::=
START_DATE = 'datetime' | EXPIRY_DATE = 'datetime'

Description

Cette instruction permet d'ajouter un certificat dans une base de données de SQL Server.



Dernière mise à jour : Vendredi, le 19 Juin 2020