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 in the database.
Before doing this recipe, you should have completed the Creating a redaction policy when using full redaction recipe.