SQL Server中的机密信息处理技巧

发布时间：2023-07-25 14:06:54 所属栏目：MsSql教程来源：

导读：<div class="codebody" id="code24421">

OPEN SYMMETRIC KEY 命令关于对称密钥加密使用证书解密

CREATE MASTER KEY ENCRYPTION BY PASSWORD = 'password'

go

CREATE CERTIFICATE CertTest

<div class="codebody" id="code24421">

OPEN SYMMETRIC KEY 命令关于对称密钥加密使用证书解密

CREATE MASTER KEY ENCRYPTION BY PASSWORD = 'password'

go

CREATE CERTIFICATE CertTest

with SUBJECT = 'Test Certificate'

GO

--创建非对称密钥

CREATE asymmetric KEY Testasymmetric

WITH ALGORITHM = RSA_2048

ENCRYPTION BY PASSWORD = 'password1' ;

GO

ALTER asymmetric KEY Testasymmetric WITH PRIVATE KEY (DECRYPTION BY PASSWORD = 'password1') --DROP asymmetric KEY Testasymmetric

--创建对称密钥

CREATE SYMMETRIC KEY TestSymmetric

WITH ALGORITHM = AES_256

ENCRYPTION BY PASSWORD = 'password' ;

GO OPEN SYMMETRIC KEY TestSymmetric

DECRYPTION BY PASSWORD = 'password' ; go

SELECT ENCRYPTBYASYMKEY(ASYMKEY_ID ('Testasymmetric'),name),

CAST(deCRYPTBYASYMKEY (ASYMKEY_ID( 'Testasymmetric'),ENCRYPTBYASYMKEY (ASYMKEY_ID( 'Testasymmetric'),name ) )

as nvarchar(200 )),

ENCRYPTBYCERT ( Cert_ID('CertTest' ),

CAST(deCRYPTBYCERT (Cert_ID ('CertTest'),ENCRYPTBYCERT (Cert_ID( 'CertTest'),name ))

as nvarchar (200)),

EncryptByKey ( KEY_GUID('TestSymmetric' ),

CAST(decryptByKey (EncryptByKey (KEY_GUID ('TestSymmetric'),name))

as nvarchar (200)) FROM sys .objects

（编辑：聊城站长网）

【声明】本站内容均来自网络，其相关言论仅代表作者个人观点，不代表本站立场。若无意侵犯到您的权利，请及时与联系站长删除相关内容!