After you decide which data is sensitive, you'll need to find all places where that data is stored. Once you do that, you'll classify the data (associate sensitive columns with sensitive types). In this recipe, you'll associate two sensitive columns (from two tables) with sensitive type you created in the previous recipe.
To complete this recipe, create a user challengezoran, create table T1, and insert several values into the table (see Figure 1) or use your own table. Also, you'll need an existing user who has an execute privilege on dbms_tsdp_manage package (for example, c##zoran).
Figure 4 - Creating table T1
Connect to the database (for example,
pdb1) as a user who has appropriate privileges (for example,c##zoranuser):$ sqlplus c##zoran@pdb1Associate a sensitive column (for example, schema
CHALLENGEZORAN, tableT1, columnEMAIL_ADDRESS) with sensitive type you created in the previous recipe (for example,email_type)
Figure 5...
