yoursyun

3DES 암호화 복호화 본문

database/mssql

3DES 암호화 복호화

yoursyun 2013. 3. 12. 11:50

OPEN MASTER KEY DECRYPTION BY PASSWORD = '암호'

OPEN SYMMETRIC KEY PasswordFieldSymmetricKey DECRYPTION BY CERTIFICATE TiwazPasswordFieldCertificate WITH PASSWORD = '암호'

DECLARE @ENC VARBINARY(256) = EncryptByKey(Key_GUID('PasswordFieldSymmetricKey'), 'AAAAA')

SELECT @ENC

SELECT CONVERT(varchar, DecryptByKey(@ENC))

반응형