A table named EMPLOYEE was created as follows: Which action will prevent unauthorized
users from accessing SSN data?
A.
Only grant ACCESSCTRL authority for the SSN column to users who need to access
SSN data.
B.
Alter the table definition so that SSN data is stored in a separate schema that only
authorized users can access.
C.
Assign the SSN column to a restricted role that only authorized users can access.
D.
Create a view for the EMPLOYEE table that does not contain the SSN column and
require unauthorized users to use the view.
Explanation: