- 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
- 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)
- 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.
You should set encryption/decryption privileges to encrypt columns or see the values encrypted. The privileges are applied to each columns per one setting.
#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.
#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; }
Continue: Access Control