Altering transparent sensitive data protection policy
In this recipe, you'll alter policy you created in recipe Creating transparent sensitive data protection policy and enable it.
Getting ready
To complete this recipe, you'll need two existing users (for example, c##zoran and maja). Also, update the table hr.employees, as shown in Figure 20:
Figure 20 - Set new e-mail addresses in the hr.employees table
How to do it...
- Connect to the database (for example,
pdb1) as a user who can manage TSDP policies (for example,c##zoran):$ sqlplus c##zoran@pdb1 - If the policy is enabled, disable it for all columns (for instructions how to disable the TSDP policy, ...
Get Oracle Database 12c Security Cookbook now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
