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

2. Assign the column encryption settings

Here, you will assign which policy is to be applied when encrypting a column. The command looks like:

MyDiamo > SET COLUMN <OWNER>”<TABLE>”<COLUMN>”<POLICY ID>

For example, if you want to encrypt the “ADDRESS” column of the “EMPLOYEE” table of “JAMES” owner(=DB name) from “SYS” user by using the “addressPolicy” policy created previously, then you would execute the command like:

MyDiamo >set column JAMES"EMPLOYEE"ADDRESS"addressPolicy