Creating security labels

The CREATE SECURITY LABEL statement defines a new security label for a specified security policy.

Before you begin

You must hold the DBSECADM role to create a security label.

About this task

When you create a security label, you complete the following steps:

  • Specify a security policy to which the label belongs.
  • Identify the components of that policy.
  • Identify one or more elements of each component.
  • Name the label.

Procedure

Create a security label by issuing the CREATE SECURITY LABEL statement, as described in HCL OneDB™ Guide to SQL: Syntax.

Example

The following example shows a CREATE SECURITY LABEL statement:
CREATE SECURITY LABEL company.label2
   COMPONENT level 'Secret',
   COMPONENT function 'Administrative',
   COMPONENT region 'Southwest';

What to do next

This statement defines label2 in security policy company.