A column mask that is to be used for row and column access control (RCAC) was created
with the DISABLE option specified. What must be done if this mask is to be used to restrict
access to data stored in a table named EMPLOYEE?
A.
The column mask must be enabled (column access control for the EMPLOYEE table will
be activated automatically).
B.
The EMPLOYEE table must be altered to activate column access control (the column
mask will be enabled automatically).
C.
The EMPLOYEE table must be altered to activate column access control; row permission
must be granted to everyone who needs to use thecolumn mask.
D.
The column mask must be enabled; the EMPLOYEE table must be altered to activate
column access control.
Syntax
Read syntax diagramSkip visual syntax diagram
>>-ALTER MASK–mask-name–+-ENABLE–+————————–>>-ALTER TABLE–table-name————————————–>
…
…
| +-+-ACTIVATE—+–ROW ACCESS CONTROL———————————-+ |
| | ‘-DEACTIVATE-‘ | |
| | (3) | |
| +-+-ACTIVATE—+–COLUMN ACCESS CONTROL——————————-+ |
| | ‘-DEACTIVATE-‘
0
0