Command Reference

Home / Resources / Guide / Command Reference

Encryption/Decryption Privilege

      You should set encryption/decryption privileges to encrypt columns or see the values encrypted. The privileges are applied to each columns per one setting.

      • SET PRIV ENC <user>”<owner>”<table>”<column>”<enc priv>”<dec priv>
      • <user>: User name to give the privilege.
      • <owner>: Owner name which owns the table with the column to encrypt.
      • <table>: Table name which has the column to encrypt.
      • <column>: Name of the column to encrypt.
      • <enc priv>: Encryption privilege. (0: do not have a privilege, 1: have a privilege)
      • <dec priv>: Decryption privilege. (0: do not have a privilege, 1: have a privilege)

      #fancy-title-6757f51c008da a{ color: #5b5b5b; }
      When you need to set both privileges to “0”, it is recommended to use DELETE PRIV ENC rather than SET PRIV ENC. This command deletes privilege setting registered.

      • DELETE PRIV ENC <user>”<owner>”<table>”<column>
      • <user>: User name who has the privilege to delete.
      • <owner>: Owner name which owns the table with the encryption column.
      • <table>: Table name which has the encryption column.
      • <column>: The name of the encryption column.
      • Explanation: Deletes privilege to encrypt or decrypt the appointed encryption column of a DB user.

      #fancy-title-6757f51c00c9e a{ color: #5b5b5b; }
      #icon-font-6757f51c00eea i { background-color:; color:#000000; border-color:; } #icon-font-6757f51c00eea i:hover { background-color:; color:rgba(0,0,0,0.51); border-color:; }

      #fancy-title-6757f51c0196e a{ color: #274e75; }