PrepAway - Latest Free Exam Questions & Answers

What must be done if this mask is to be used to restrict access to data stored in a table named EMPLOYEE?

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?

PrepAway - Latest Free Exam Questions & Answers

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.

One Comment on “What must be done if this mask is to be used to restrict access to data stored in a table named EMPLOYEE?

  1. Chow, Kenneth KY says:

    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

Leave a Reply