An Administrator has been asked to support the company's application team need to build a loyalty program for its customers. The customer table contains Personal Identifiable Information (PII), and the application team's role is DEVELOPER. CREATE TABLE customer_data ( customer_first_name string, customer_last_name string, customer_address string, customer_email string, ... some other columns, ); The application team would like to access the customer data, but the email field must be obfuscated. How can the Administrator protect the sensitive information, while maintaining the usability of the data?

Question

Accepted Answer

D. Use the CURRENT_ROLE context function to integrate with a masking policy on the fields that

Answer

A. Create a view on the customer_data table to eliminate the email column by omitting it from the

Answer

B. Create a separate table for all the non-Pll columns and grant the role DEVELOPER access to the

Answer

C. Use the CURRENT_ROLE and CURRENT_USER context functions to integrate with a secure

An Administrator has been asked to support the company's application team need to build a loyalty program for its customers. The customer table contains Personal Identifiable Information (PII), and…

Question

Options

How the community answered

Community Discussion