>>-SECLABEL--(--security-policy-name--,--security-label-string--)-><
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.
- 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.
- 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')
- 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')