A table named EMPLOYEE was created as follows:
Which action will prevent unauthorized users from accessing SSN data?
A. Assign the SSN column to a restricted role that only authorized users can access.
B. Only grant ACCESSCTRL authority for the SSN column to users who need to access SSN data.
C. Alter the table definition so that SSN data is stored in a separate schema 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.
|
Download Printable PDF. VALID exam to help you PASS. |
 |