Encryption

• Page 1: 1. Create Encryption Policy
• Page 2: 2. Assign the column encryption settings
• Page 3: 3. Grant Encryption Privileges
• Page 4: 4. Save MyDiamo Setting
• Page 5: 5. Migrate Table to MyDiamo Storage

1. Create Encryption Policy

To complete encryption, you need to migrate the encryption set table to MyDiamo Storage. At this point, the DB engine of the table will change to DAMO_MYISAM or DAMO_INNODB depending on the original storage engine. Please be cautious that you should access mysql with privileged user. The command looks like:

 mysql > call mysql.damo_table_migration(‘<OWNER>’,’<TABLE>’);

To encrypt the table used as an example above, you should access mysql with SYS user and type command below in MySQL command like:

mysql >call mysql.damo_table_migration('JAMES', 'EMPLOYEE');