Home
SecurityYou can secure your HCL OneDB™ database server and the data that is stored in your HCL OneDB™ databases. You can encrypt data, secure connections, control user privileges and access, and audit data security.
Security in HCL OneDB™The HCL OneDB™ Security Guide documents methods for keeping your data secure by preventing unauthorized viewing and altering of data or database objects, including how to use the secure-auditing facility of the database server.
Securing data
Label-Based Access ControlYou can use label-based access control (LBAC), an implementation of multi-level security (MLS), to control who has read access and who has write access to individual rows and columns of data.
Security label componentsSecurity label components are security objects for defining security policies. The elements of these components are used to define security labels, which control access to protected tables.
Creating security label componentsThe CREATE SECURITY LABEL COMPONENT statement defines this database security object.

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'};