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:

SQL> SELECT POLICY_NAME, SENSITIVE_TYPE FROM DBA_TSDP_POLICY_TYPE;

See also

• Creating a sensitive type

• Determining sensitive columns

• Creating transparent sensitive data protection policy