Oracle Database 12c Security Cookbook

Associating transparent sensitive data protection policy with sensitive type

In this recipe, you'll associate TSDP policy and sensitive type you created in the previous recipes.

Getting ready

To complete this recipe, you'll need an existing user who has the execute privilege on the dbms_tsdp_protect package (for example, c##zoran).

How to do it...

1. Connect to the database as a user (for example, pdb1) who has appropriate privileges (for example, c##zoran user):

   $ sqlplus c##zoran@pdb1
   

2. Associate TSDP policy with sensitive type:
   

There's more...

To verify that you successfully associated the TSDP policy and the sensitive type, execute the following query: ...