Altering security label components

The ALTER SECURITY LABEL COMPONENT statement adds one or more new elements to an existing component.

Before you begin

You must hold the DBSECADM role to add one or more elements to a security label component, and you must know what type of component it is.

About this task

When you alter a security label component, remember the following rules:
  • A security label component can consist of no more than 64 elements.
  • If the component you want to alter is of type ARRAY or TREE, you must know the relationships that all the elements of the resulting component have with one another.
  • The ALTER SECURITY LABEL COMPONENT statement cannot modify or drop any existing elements.

Procedure

Add one or more elements to a security label component by issuing the ALTER SECURITY LABEL COMPONENT statement, as described in HCL OneDB™ Guide to SQL: Syntax.

Example

The following example shows an ALTER SECURITY LABEL COMPONENT statement that adds to a SET-type component the elements Training, QA, and Security:
ALTER SECURITY LABEL COMPONENT department
   ADD SET {'Training', 'QA', 'Security'};