Home
SQL programmingYou can use the HCL OneDB™ implementation of the SQL language to develop applications for HCL OneDB™ database servers.
Guide to SQL: SyntaxThe HCL OneDB™ Guide to SQL: Syntax describes the syntax of the statements, data types, expressions, operators, and built-in functions of the HCL OneDB™ dialect of the SQL language.
SQL statementsThis chapter describes the syntax and semantics of SQL statements that are recognized by HCL OneDB™.
CREATE SECURITY LABEL COMPONENT statementUse the CREATE SECURITY LABEL COMPONENT statement to define a new security label component in the current database and to define the elements the component.
SET Components

SET Components

A security label component of type SET is an unordered set of no more than 64 elements. Each element of the SET is a string constant of no more than 32 bytes, and must be unique within the component, but the same value can be used in other components. The order in which the elements of a SET component are declared is not significant in regard to the data sensitivity of the categories that these elements identify. The elements and their comma separators must be enclosed between a pair of braces ( { ... } ) symbols.

When a SET component is specified in the definition of a security label, the label can specify one or multiple elements of that component as valid values for the component.

In the following example, DBSECADM defines a security label component called departments that is an unordered set of three elements, called Marketing, HR, and finance:

CREATE SECURITY LABEL COMPONENT departments 
   SET { 'Marketing', 'HR', 'Finance' };

Like all components of type SET, the order in which these elements are declared implies no relative rank in data sensitivity.

A component of type SET can be appropriate in contexts where some dimension of a multidimensional security policy can be represented as nominal categories, without any logical basis for ordering them on a monotonic scale, nor for arranging them in a hierarchy.