Buscar en la base de conocimiento

MSSQL Encryption

Simple steps to create a encrypted database
1. Create a masterkey

Create master key encryption by password='STRONG_PASSWORD_HERE'

2. Create certificate

create certificate CERTIFICATE_NAME with subject ='CERTIFICATE_SUBJECT_OR_INFO'

3. Create a symmetric key
CREATE SYMMETRIC KEY key_name
WITH ALGORITHM = AES_256
ENCRYPTION BY CERTIFICATE CERTIFICATE_NAME


4. In every query or stored procedure make sure to call and decrypt your key
OPEN SYMMETRIC KEY key_name DECRYPTION BY CERTIFICATE Certificate_name;

Ej Select: SELECT CONVERT (VARCHAR (200), DECRYPTBYKEY(nombre)) AS nombre,



ej Insert: INSERT INTO registro (nombre, email, telefono, correctas, registro)
VALUES (ENCRYPTBYKEY(KEY_GUID('SSN_Key_01'), @nombre), ENCRYPTBYKEY(KEY_GUID('SSN_Key_01'), @email), ENCRYPTBYKEY(KEY_GUID('SSN_Key_01'), @telefono), 0, @registro);

¿Le ha resultado útil este artículo?

Articulos relacionados