Enabling, disabling, and dropping redaction policy

In this recipe, you will perform the three basic tasks: enabling, disabling, and dropping the same redaction policy (CUST_POL), which you defined in the Creating a redaction policy when using full redaction recipe using SQL*Plus. Also, you will check which redaction policies exist in the database and whether they are enforced (enabled).

To minimize dependence on the previous recipes in this chapter, a result shown after querying data dictionary view is equivalent to the one you would get if you completed only the Creating a redaction policy when using full redaction recipe before starting to do this recipe. The only difference you may see in the result is the number of existing redaction policies ...

Get Oracle Database 12c Security Cookbook now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.