- Page 1: 1. Grant Decryption Privileges
- Page 2: 2. Save MyDiamo Setting
- Page 3: 3. Migrate Table to MyDiamo Storage
3. Migrate Table to MyDiamo Storage
- Decryption can be done by typing the ALTER statement printed after encryption on the MySQL command line. At this point, the DB engine of the table will change to MySQL Storage. Please be cautious that you should access mysql with privileged user. The command looks like:
alter table <OWNER>.<TABLE> engine=‘<STORAGE ENGINE>’;
To decrypt the table used as an example above, you should access mysql with SYS user and type command below in MySQL command like:
mysql >alter table JAMES.EMPLOYEE engine='MyISAM';
NOTE!
We recommend to delete MyDiamo Setting that you no longer use. The command to delete encryption column setting is like:
DELETE COLUMN <OWNER>”<TABLE>”<COLUMN>
Be cautious when you delete encryption column setting since even though you re-set encryption with the same policy, the key will change.
#mk-custom-box-6766f36e40558 { padding:30px 20px; margin-bottom:20px; background-attachment:scroll; background-repeat:repeat; background-color:#ebebeb; background-position:left top; } #mk-custom-box-6766f36e40558 .mk-divider .divider-inner i{ background-color: #ebebeb !important; }
Back to: 1. Grant Decryption Privileges