Applying column-level protection

Protect column-level data by associating the table with a security policy and attaching a security label to one or more columns.

About this task

There are two methods for applying column-level protection:

Procedure

  1. For a new table: Use the CREATE TABLE statement with the COLUMN SECURED WITH and SECURITY POLICY clauses, as described in HCL OneDB™ Guide to SQL: Syntax.
  2. For an existing table: Use the ALTER TABLE statement with the MODIFY (your_column COLUMN SECURED WITH) and ADD SECURITY POLICY clauses, as described in HCL OneDB Guide to SQL: Syntax.

Example

The following example shows a statement that applies column-level protection when a new table (T3) is created by using the security policy named company and a security label named label4.
CREATE TABLE T3 
   (C1 CHAR (8),
   C2 int COLUMN SECURED WITH label4,
   C3 char (10))
   SECURITY POLICY company;

The following statement provides an example of applying column-level protection on a table (T4) that already exists on the database by using the security policy named company and a security label named label5.

ALTER TABLE T4 
   MODIFY (C1 CHAR (8) COLUMN SECURED WITH label5), 
   ADD SECURITY POLICY company;