Harold is creating an Oracle Label Security Policy on his server. He has define the policy and
defined the components of the labels already. Now Harold creates the labels dynamically using
the TO_DATA_LABEL function:
INSERT INTO emp (ename, empnum, hr_label)
VALUES (‘FGRIFFIN’, 10 to_data_label (‘HR’, ‘SENSITIVE’));
Harold gets an error reffering to permission when he tries to run this function. What authority must
Harold have to run the TO_DATA_LABEL function?
A.
EXECUTE
B.
WRITE
C.
INSERT
D.
CREATE
Explanation: