Altering security label components

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

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.

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.

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

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