A table named SALES was created as follows:
If management wants to use Label-Based Access Control (LBAC) to protect individual columns in the SALES
table, and the security policy needed (SEC_POLICY) has already been created, what must be done to protect
the table as desired?
A.
Associate the SEC_POLICY security policy with the SALES table.
B.
Add a SECURED WITH clause to every column in the SALES table.
C.
Add a column with the DB2SECURITYLABEL data type to the SALES table and then associate the
SEC_POLICY security policy with the table.
D.
Add a SECURED WITH clause to every column in the SALES table and then associate the SEC_POLICY
security policy with the SALES table.
COLUMN SECURED WITH security-label-name
Identifies a security label that exists for the security policy that is associated with the table. The name must not be qualified (SQLSTATE 42601). The table must have a security policy associated with it (SQLSTATE 55064).
0
0