Section courante

A propos

Section administrative du site

CREATE SYMMETRIC KEY

Crée une clef symétrique
  Microsoft SQL Server

Syntaxe

CREATE SYMMETRIC KEY key_name
[ AUTHORIZATION owner_name ]
[ FROM PROVIDER provider_name ]
WITH
[
key_options [ , ... n ]
| ENCRYPTION BY encrypting_mechanism [ , ... n ]
]

key_options ::=
KEY_SOURCE = 'pass_phrase'
| ALGORITHM = algorithm
| IDENTITY_VALUE = 'identity_phrase'
| PROVIDER_KEY_NAME = 'key_name_in_provider'
| CREATION_DISPOSITION = {CREATE_NEW | OPEN_EXISTING }

algorithm ::=
DES | TRIPLE_DES | TRIPLE_DES_3KEY | RC2 | RC4 | RC4_128
| DESX | AES_128 | AES_192 | AES_256

encrypting_mechanism ::=
CERTIFICATE certificate_name
| PASSWORD = 'password'
| SYMMETRIC KEY symmetric_key_name
| ASYMMETRIC KEY asym_key_name

Description

Cette instruction permet de générer une clef symétrique et spécifie ses propriétés dans SQL Server.



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