1 / 8

Enkripsi dan Dekripsi Data

Enkripsi dan Dekripsi Data. Proses. Enkripsi Me ngubah plaintext menjadi ciphertext Dekripsi Mengubah ciphertext menjadi plaintext. Tahapan. Create Database Master Key Create Encryption Certificate Create Symmetric Key Encrypt Data using Key and Certificate

kina
Download Presentation

Enkripsi dan Dekripsi Data

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Enkripsi dan Dekripsi Data dfd, 2014

  2. Proses • Enkripsi Mengubah plaintext menjadi ciphertext • Dekripsi Mengubah ciphertext menjadi plaintext dfd, 2014

  3. Tahapan • Create Database Master Key • Create Encryption Certificate • Create Symmetric Key • Encrypt Data using Key and Certificate • Decrypt Datausing Key and Certificate dfd, 2014

  4. Create Database Master Key CREATE MASTER KEY ENCRYPTION BY PASSWORD =‘password‘ Ket: Password diisi dengan password yang anda inginkan dfd, 2014

  5. Create Encryption Certificate CREATE CERTIFICATE nama_sertifikat WITH SUBJECT =‘nama_subjek' dfd, 2014

  6. Create Symmetric Key CREATE SYMMETRIC KEYnama_kunci_simetris WITH ALGORITHM = nama_algoritma ENCRYPTION BY CERTIFICATE nama_sertifikat Nama algoritma : DES, TRIPLE_DES, RC2, RC4, RC4_128, DESX, AES_128, AES_192, and AES_256 dfd, 2014

  7. Encrypt Data • OPEN SYMMETRIC KEYnama_kunci_simetris • DECRYPTION BY CERTIFICATE nama_sertifikat • Fungsi enkripsi ENCRYPTBYKEY(KEY_GUID('nama_kunci_simetris '),dataenkrip) Ket : dataenkrip dapat mengacu ke kolom tertentu dari suatu tabel atau nilai/values tertentu fungsi enkripsi digunakan pada operasi DML dfd, 2014

  8. Decrypt Data OPEN SYMMETRIC KEYnama_kunci_simetris DECRYPTION BY CERTIFICATE nama_sertifikat Fungsi Dekripsi CONVERT(VARCHAR(50), DECRYPTBYKEY(nama_kolom_enkripsi)) Ket : Dapat dikombinasikan dengan menggunakan perintah SELECT dfd, 2014

More Related