IBM Exam Questions

Which action will prevent unauthorized users from accessing SSN data?

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.

Explanation: