page253
340
Create a table called
client_filter
along with sequence
seq_client_filter_id
to
generate surrogate keys.
CREATE OR REPLACE TABLE client_filter
(
client_filter_id NUMBER,
client_id NUMBER REFERENCES client ( client_id ),
filter_name VARCHAR(255),
filter_attribute VARCHAR(255),
filter_value VARCHAR(255)
);
CREATE OR REPLACE SEQUENCE seq_client_filter_id START WITH 100000;
Apply a single filter to
base_customer_order.region_name
for
AFRICA
.
INSERT INTO client_filter
SELECT seq_client_filter_id.NEXTVAL,
( SELECT client_id FROM client WHERE name = 'POC' ),
'[REGION]',
'region_name',
'AFRICA';
Client Mask
Masks refer to the object physical attributes holding data you want to mask. Equivalent
to data masking, this section enables data masking at object generation time.
Create a table called
client_mask
along with a sequence called
seq_client_mask_id
to generate surrogate keys.
CREATE OR REPLACE TABLE client_mask
(
client_mask_id NUMBER,
client_id NUMBER REFERENCES client ( client_id ),
mask_name VARCHAR(255),
mask_attribute VARCHAR(255),
mask_value VARCHAR(255)
);
CREATE OR REPLACE SEQUENCE seq_client_mask_id START WITH 100000;
Chapter 9
Client expeCtations