Table of Contents
- Title and Copyright Information
- Preface
- Changes in This Release for Oracle AI Database Data Redaction Guide
- Enhancements to Oracle Data Redaction
- Complex Expression on Redacted Columns in Views
- Extended Statistics and Functional Indexes on Redacted Columns
- GROUP BY on Expression On Columns With Redaction Policies
- DISTINCT with ORDER BY on Redacted Column
- Inline View with Set Operation Having a Subquery
- Set Operator with Redacted Columns
- Redaction Results for Queries with SQL Expressions and Set Operation When Using Columns With Redaction Policies
- Optimization of Policy Expressions
- Schema Privileges to Simplify Access Control in Oracle Data Redaction
- BOOLEAN Data Type Supported in Oracle Data Redaction
- Enhancements to Oracle Data Redaction
- Introduction to Oracle Data Redaction
- Oracle Data Redaction Features and Capabilities
- Getting Started with Oracle Data Redaction
- Full Data Redaction to Redact All Data
- Partial Data Redaction to Redact Portions of Data
- Regular Expressions to Redact Patterns of Data
- Random Data Redaction to Generate Random Values
- Redaction Using Null Values
- No Redaction for Testing Purposes
- Comparison of Full, Partial, Regexp, Random, and Nullify Redaction Based on Data Types
- Central Management of Data Redaction Named Policy Expressions
- Configuring Oracle Data Redaction Policies
- About Oracle Data Redaction Policies
- Privileges for Managing Oracle Data Redaction Policies
- General Syntax of the DBMS_REDACT.ADD_POLICY Procedure
- Planning an Oracle Data Redaction Policy
- Using Expressions to Define Conditions for Data Redaction Policies
- About Using Expressions in Data Redaction Policies
- Supported Functions for Data Redaction Expressions
- Applying the Redaction Policy Based on User Environment
- Applying the Redaction Policy Based on Database Roles
- Applying the Redaction Policy Based on Application Express Session States
- Applying the Redaction Policy Based on Oracle Label Security Label Dominance
- Managing the Application of Redaction Policies to All Users
- Creating and Managing Multiple Named Policy Expressions
- About Data Redaction Policy Expressions to Define Conditions
- Creating and Applying a Data Redaction Named Policy Expression
- Updating a Data Redaction Named Policy Expression
- Dropping a Data Redaction Named Policy Expression
- Tutorial: Creating and Sharing a Data Redaction Named Policy Expression
- Step 1: Create Users for This Tutorial
- Step 2: Create an Oracle Data Redaction Policy
- Step 3: Test the Oracle Data Redaction Policy
- Step 4: Create and Apply a Named Policy Expression to the Redacted Table Columns
- Step 5: Test the Data Redaction Named Policy Expression
- Step 6: Modify the Data Redaction Named Policy Expression
- Step 7: Test the Modified Named Policy Expression
- Step 8: Remove the Components of This Tutorial
- Creating a Full Redaction Policy and Altering the Full Redaction Value
- Creating a Partial Redaction Policy
- About Creating Partial Redaction Policies
- Syntax for Creating a Partial Redaction Policy
- Creating Partial Redaction Policies Using Fixed Character Formats
- Creating Partial Redaction Policies Using Character Data Types
- Creating Partial Redaction Policies Using Number Data Types
- Creating Partial Redaction Policies Using Date-Time Data Types
- Creating a Regular Expression-Based Redaction Policy
- Creating a Random Redaction Policy
- Creating a Nullify Redaction Policy
- Creating a Policy That Uses No Redaction
- Exemption of Users from Oracle Data Redaction Policies
- Redacting Multiple Columns
- Altering an Oracle Data Redaction Policy
- Disabling and Enabling an Oracle Data Redaction Policy
- Dropping an Oracle Data Redaction Policy
- Tutorial: SQL Expressions to Build Reports with Redacted Values
- Integrating Oracle Data Redaction with Other Oracle Products and Features
- Oracle Data Redaction and DML and DDL Operations
- Oracle Data Redaction and Nested Functions, Inline Views, and the WHERE Clause
- Redaction Results for Queries with SQL Expressions and Set Operation When Using Columns With Redaction Policies
- Oracle Data Redaction Policy and Object Transfers with Oracle Data Pump
- Oracle Data Redaction and Oracle Virtual Private Database
- Oracle Data Redaction and Oracle Database Real Application Security
- Oracle Data Redaction and Oracle Database Vault
- Oracle Data Redaction and Data Masking and Subsetting Pack
- Oracle Data Redaction and Transparent Data Encryption
- Considerations for Oracle Data Redaction
- Oracle Data Redaction General Security Guidelines
- Restriction of Administrative Access to Oracle Data Redaction Policies
- How Oracle Data Redaction Affects the SYS, SYSTEM, and Default Schemas
- Policy Expressions That Use SYS_CONTEXT Attributes
- Oracle Data Redaction Policies on Materialized Views
- Oracle Data Redaction and Object Dependencies
- Oracle Data Redaction and Cursor Expression Queries on Columns Protected by Data Redaction Policies
- Redaction Results of a SQL Expression When Using Multiple Columns With Different Policy Expressions
- Limitations of Oracle Data Redaction
- Frequently Asked Questions
- Using Trace Files to Troubleshoot Oracle Data Redaction Policies
- Oracle Data Redaction Policy Data Dictionary Views
- DBMS_REDACT
- Managing Oracle Data Redaction Policies in Oracle Enterprise Manager
- About Using Oracle Data Redaction in Oracle Enterprise Manager
- Oracle Data Redaction Workflow
- Management of Sensitive Column Types in Enterprise Manager
- Managing Oracle Data Redaction Formats Using Enterprise Manager
- About Managing Oracle Data Redaction Formats Using Enterprise Manager
- Creating a Custom Oracle Data Redaction Format Using Enterprise Manager
- Editing a Custom Oracle Data Redaction Format Using Enterprise Manager
- Viewing Oracle Data Redaction Formats Using Enterprise Manager
- Deleting a Custom Oracle Data Redaction Format Using Enterprise Manager
- Managing Oracle Data Redaction Named Policy Expressions Using Enterprise Manager
- About Managing Oracle Data Redaction Policies Using Enterprise Manager
- Creating an Oracle Data Redaction Policy Using Enterprise Manager
- Editing an Oracle Data Redaction Policy Using Enterprise Manager
- Viewing Oracle Data Redaction Policy Details Using Enterprise Manager
- Enabling or Disabling an Oracle Data Redaction Policy in Enterprise Manager
- Deleting an Oracle Data Redaction Policy Using Enterprise Manager
- Managing Data Redaction Named Policy Expressions Using Enterprise Manager
- About Data Redaction Named Policy Expressions in Enterprise Manager
- Creating a Data Redaction Named Policy Expression in Enterprise Manager
- Editing a Data Redaction Named Policy Expression in Enterprise Manager
- Viewing Data Redaction Named Policy Expressions in Enterprise Manager
- Deleting a Data Redaction Named Policy Expression in Enterprise Manager