Command Reference

Home / 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-5f2ab9375dd10 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-5f2ab9375e0cd a{ color: #5b5b5b; }
      #icon-font-5f2ab9375e326 i { background-color:; color:#000000; border-color:; } #icon-font-5f2ab9375e326 i:hover { background-color:; color:rgba(0,0,0,0.51); border-color:; }

      #fancy-title-5f2ab9375edc0 a{ color: #274e75; }