Oracle Database 12c Security Cookbook

Determining sensitive columns

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.

Getting ready

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 ...