Command Reference

• Page 1: Log
• Page 2: Save & Reload
• Page 3: Convenience
• Page 4: Policy
• Page 5: Encryption/Decryption Privilege
• Page 6: Access Control
• Page 7: Column Encryption Settings

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-66a49451c3cbd 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-66a49451c4098 a{ color: #5b5b5b; }
#icon-font-66a49451c42e7 i { background-color:; color:#000000; border-color:; } #icon-font-66a49451c42e7 i:hover { background-color:; color:rgba(0,0,0,0.51); border-color:; }
#fancy-title-66a49451c4dbf a{ color: #274e75; }
Continue: Access Control