Creating a sensitive type

To create a sensitive type, you can use Oracle Enterprise Manager or a command-line interface. In this recipe, you'll use the command-line interface to execute a PL/SQL procedure. You decided that you want to protect e-mail addresses stored in your database, so first you are going to create sensitive type email_type.

Getting ready

To complete this recipe, you'll need an existing user who can create a sensitive type (for example, c##zoran).

How to do it...

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

   $ sqlplus c##zoran@pdb1
   

2. Create a sensitive type (for example, email_type):

   SQL> BEGIN 
    DBMS_TSDP_MANAGE.ADD_SENSITIVE_TYPE ( 
    sensitive_type => '<your_type>', 
    user_comment=> '<description>');
    END;
    /
   

   

   Figure 2 - Creating a sensitive type

How it works...

In step 2, you created a sensitive type (for example, email_type), which you can use to consistently mask (protect), in our case, e-mail...