Creating security label components

The CREATE SECURITY LABEL COMPONENT statement defines this database security object.

Before you begin

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

About this task

When you create a security label component you must provide the following information:
  • A name for the component
  • The type of component it is (ARRAY, SET, or TREE)
  • A complete list of elements

Procedure

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

Example

The following example shows a CREATE SECURITY LABEL COMPONENT statement that creates a SET-type component with name department and elements Marketing, HR, and Finance:
CREATE SECURITY LABEL COMPONENT department
   SET {'Marketing', 'HR', 'Finance'};