Command Reference

Home / Resources / Guide / Command Reference


Making policy, you can determine what encryption algorithm will be applied, whether to use VIV or FIV, and whether to encrypt partially or entirely. You can assign different policies to each columns.

  • CREATE POLICY <policy id>”<enc algorithm id>”<iv mode>[“<partial-enc-pos>”<partial-enc-off>] <ENCODING>
  • <policy id>: policy identity making each policy unique
  • <enc algorithm id>: algorithm to be used for encryption
  • supported encryption algorithms: TDES, AES, BLOWFISH, RC4
  • <iv mode>: VIV or FIV
  • VIV: Variable Initial Vector. Cyphertexts encrypted from same plaintext can have different values.
  • FIV: Fixed Initial Vector. Cyphertexts encrypted from same plaintext always have same values. Recommended to use for special reasons such as PK or FK.
  • <partial-enc-pos>: Start position of partial encryption. If not specified, encrypt from the beginning.
  • <partial-enc-off>: The length of text to encrypt partially. If not specified, encrypt to the end.
  • <ENCODING>: Select how to encode encrypted data as RAW or BASE64 or HEXSTRING

#fancy-title-664cc3d6a2d2a a{ color: #5b5b5b; }

  • DELETE POLICY <policy id>
  • Explanation: Deletes entered policy. If there is at least 1 column encrypted by that column, deletion cannot be done.

#fancy-title-664cc3d6a2fc4 a{ color: #5b5b5b; }
When a policy is deleted and a new policy with the same settings is created, the key is different from the old one’s, so be careful when deleting policies. We recommend to delete unnecessary policies so that they do not waste system resources.
#mk-custom-box-664cc3d6a31f8 { padding:10px 20px; margin-bottom:20px; background-attachment:scroll; background-repeat:repeat; background-color:#ebebeb; background-position:left top; } #mk-custom-box-664cc3d6a31f8 .mk-divider .divider-inner i{ background-color: #ebebeb !important; }
#icon-font-664cc3d6a3868 i { background-color:; color:#000000; border-color:; } #icon-font-664cc3d6a3868 i:hover { background-color:; color:rgba(0,0,0,0.51); border-color:; }

#fancy-title-664cc3d6a45e1 a{ color: #274e75; }