SECLABEL scalar function
The SECLABEL function returns an unnamed security label with a data type of DB2SECURITYLABEL. Use the SECLABEL function to insert a security label with given component values without having to create a named security label.
The schema is SYSIBM.
- security-policy-name
- A string that specifies a security policy that exists at the current server (SQLSTATE 42704). The string must be a character or graphic string constant or host variable.
- security-label-string
- An expression that returns a valid representation of a security label for the security policy named by security-policy-name (SQLSTATE 4274I). The expression must return a value that is a built-in CHAR, VARCHAR, GRAPHIC, or VARGRAPHIC data type.
Examples
- Example 1: The following statement inserts a row in table
REGIONS which is protected by the security policy named CONTRIBUTIONS.
The security label for the row to be inserted is given by the SECLABEL
function. The security policy CONTRIBUTIONS has two components. The
security label given has the element LIFE MEMBER for first component,
the elements BLUE and YELLOW for the second component.
INSERT INTO REGIONS VALUES (SECLABEL('CONTRIBUTIONS', 'LIFE MEMBER:(BLUE,YELLOW)'), 1, 'Northeast')
- Example 2: The following statement inserts a row in table
CASE_IDS which is protected by the security policy named TS_SECPOLICY,
which has three components. The security label is provided by the
SECLABEL function. The security label inserted has the element HIGH
PROFILE for the first component, the empty value for the second component
and the element G19 for the third component.
INSERT INTO CASE_IDS VALUES (SECLABEL('TS_SECPOLICY', 'HIGH PROFILE:():G19') , 3, 'KLB')