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-5c0f662173e49 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-5c0f662174300 a{ color: #5b5b5b; }
    #icon-font-5c0f6621745f4 i { background-color:; color:#000000; border-color:; } #icon-font-5c0f6621745f4 i:hover { background-color:; color:rgba(0,0,0,0.51); border-color:; }

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