A company wants to apply column-level access controls in Redshift so analysts can query a table but cannot see the SSN column. How should this be implemented?
-
A
Delete the SSN column before loading data
-
B
Use Redshift column-level security with GRANT/REVOKE on specific columns
-
C
Create a separate table without the SSN column for analysts
-
D
Encrypt the SSN column with a customer-managed KMS key