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