In this recipe, you'll associate TSDP policy and sensitive type you created in the previous recipes.
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
).
Connect to the database as a user (for example,
pdb1
) who has appropriate privileges (for example,c##zoran
user):$ sqlplus c##zoran@pdb1
Associate TSDP policy with sensitive type:
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;