Index

A C D E G I J L M N O P R S T U V

A

actual data 2.3
ADD_POLICY Procedure D.5.1
ad hoc tools
- Oracle Data Redaction 1.4.4
administrative access to policies, restricting 5.2
ALTER_POLICY Procedure D.5.2
APEX_UTIL.GET_NUMERIC_SESSION_STATE function
- Oracle Data Redaction policies (NV public function) 3.5.5
APEX_UTIL.GET_SESSION_STATE function
- Oracle Data Redaction policies (V public function) 3.5.5
APPLY_POLICY_EXPR_TO_COL Procedure D.5.3

C

CDBs
- Data Redaction masking policies 1.5
column sensitive type discovery
- enabling when creating a Data Redaction policy E.5.2
CREATE_POLICY_EXPRESSION Procedure D.5.4

D

database links
- with Oracle Data Redaction policies 6.2
database roles
- Data Redaction policies 3.5.4
data redaction
- See: Oracle Data Redaction
Data Redaction supported functions 3.5.1
DDL statements
- Oracle Data Redaction policies 4.1, 4.2
DISABLE_POLICY Procedure D.5.5
DISTINCT clause, Data Redaction policies 6.1
DML statements
- Oracle Data Redaction policies 4.1, 4.2
DROP_POLICY_EXPRESSION Procedure D.5.7
DROP_POLICY Procedure D.5.6

E

editing custom formats E.4.3
editing policies E.5.3
ENABLE_POLICY Procedure D.5.8
EXEMPT REDACTION POLICY privilege
- using with Database Vault 5.2
expressions 3.5.1
- LENGTH functions, character string 3.5.2.3
- namespace functions 3.5.2.1
- Oracle Application Express 3.5.2.4
- Oracle Label Security functions 3.5.2.5
- SUBSTR function 3.5.2.2

G

GROUP BY clause, Data Redaction policies 6.1
guidelines
- materialized views and Data Redaction 5.5
- recycle bin and Data Redaction 5.1.2
- SYS_CONTEXT values and Data Redaction 5.4
guidelines, general usage
- redacted columns and DISTINCT clause 6.1
- redacted columns and GROUP BY clause 6.1
- redacted columns and ORDER BY clause 6.1
guidelines, security
- ad hoc query attacks and Data Redaction 5.1
- application context value handling by Data Redaction policies 5.1
- day-to-day operations and Data Redaction 5.1
- DDL statements and Data Redaction policies 5.1
- exhaustive SQL queries and inference and Data Redaction 5.1

I

inference, used to find data by repeatedly using a query 5.1
intruders
- ad hoc query attacks 5.1

J

JSON
- Oracle Data Redaction 6.5

L

LENGTH functions, character string
- expressions 3.5.2.3

M

masking
- See: Oracle Data Redaction
materialized views
- Data Redaction guideline 5.5

N

namespace functions
- expressions 3.5.2.1
NV public function (APEX_UTIL.GET_NUMERIC_SESSION_STATE function), Data Redaction policies 3.5.5

O

OLS_LABEL_DOMINATES public function
- Data Redaction policies 3.5.6
ORA-00979 error
- not a GROUP BY expression error 6.1
ORA-28081
- Insufficient privileges - the command references a redacted object error 4.1, 4.2
Oracle Application Express
- filtering using by session state in Data Redaction policies 3.5.5
Oracle Application Expression
- expressions 3.5.2.4
Oracle Database Real Application Security
- Data Redaction 4.6
Oracle Database Vault
- using with Data Redaction 5.2
Oracle Data Pump
- exported data from Data Redaction policies 4.4.3
- exporting Oracle Data Redaction objects 4.4.2.1
- imported data from Data Redaction policies 4.4.4
- Oracle Data Redaction security policy 4.4.1
Oracle Data Redaction 2.6
- about 1.1
- actual data 2.3
- ad hoc tools 1.4.4
- benefits 1.3
- CDBs 1.5
- creating custom format E.4.2
- DBMS_REDACT.ADD_POLICY procedure
  - using 3.4
- DBMS_REDACT.ALTER_POLICY procedure
  - about 3.15.1
  - example 3.15.4
  - parameters required for various actions 3.15.3
  - syntax 3.15.2
- DBMS_REDACT.DISABLE_POLICY
  - about 3.16.1
  - example 3.16.1
  - syntax 3.16.1
- DBMS_REDACT.DROP_POLICY
  - about 3.17
  - examples 3.17
  - syntax 3.17
- DBMS_REDACT.ENABLE_POLICY
  - about 3.16.2
  - example 3.16.2
  - syntax 3.16.2
- DBMS_REDACT.UPDATE_FULL_REDACTION_VALUES procedure
  - about 3.7.2.1
  - syntax 3.7.2.2
  - using 3.7.2.3
- deleting policies E.5.6
- editing custom format E.4.3
- editions 6.4
- Enterprise Manager Cloud Control E.4.1, E.4.2, E.4.3, E.5.1
- Enterprise Manager Cloud Control, about E.1
- Enterprise Manager Cloud Control workflow E.2
- exporting data using Data Pump Export 4.4.3
- exporting objects using Data Pump 4.4.2.1
- full data redaction
  - about 2.2
  - creating policy for 3.7.1.1
  - examples 3.7.1.3
  - modifying default value 3.7.2.1
  - syntax 3.7.1.2
- functions used in expressions 3.5.2
- getting started using 2.1
- how differs from Oracle Database Real Application Security masking 4.6
- how differs from Oracle Virtual Private Database masking 4.5
- importing data using Data Pump Import 4.4.4
- JSON 6.5
- managing policies E.5.1
- named policy expressions
  - about 2.9
- no data redaction
  - about 2.7, 3.12.1
  - creating policies for 3.12.1
  - example 3.12.2
  - syntax 3.12.1
- Oracle Data Pump security policy 4.4.1
- Oracle Enterprise Manager Data Masking and Subsetting Pack 4.8
- partial data redaction
  - about 2.3
  - character types, policies for 3.8.4.1
  - data-time data types 3.8.6.1
  - example using character data type 3.8.4.2
  - example using data-time data type 3.8.6.2
  - example using fixed character format 3.8.3.2
  - example using number data type 3.8.5.2
  - formats, fixed character 3.8.3.1
  - number data types 3.8.5.1
  - syntax 3.8.2
- policy expressions
  - about 3.6.1
  - creating 3.6.2
  - dropping 3.6.4
  - tutorial 3.6.5
  - updating 3.6.3
- prevention of data exposure by management tools 1.4.2
- privileges for creating policies 3.2
- queries on columns protected by Data Redaction policies 5.7
- random data redaction
  - about 3.10.1
  - creating policies for 3.10.1
  - example 3.10.2
- randomized data redaction
  - about 2.5
- redaction of data in read-only static pages 1.4.1
- redaction of data used in offline analytics 1.4.3
- regular expression data redaction
  - creating policies for 3.9.1
  - custom, creating policies for 3.9.4
  - example 3.9.3.2
  - example of custom 3.9.4.2
  - formats 3.9.3.1
  - formats, creating policies for 3.9.3
  - settings for 3.9.4.1
  - syntax 3.9.2
- regular expression redaction
  - about 2.4
- returning null values
  - about 3.11.1
  - example 3.11.3
  - syntax 3.11.2
- SYS schema objects 5.3
- SYSTEM schema objects 5.3
- use cases 1.4
- when to use 1.2
Oracle Data Redaction, database links 6.2
Oracle Data RedactionEnterprise Manager Cloud Control
- deleting custom format E.4.5
Oracle Data Redaction formats
- creating in Cloud Control E.4.2
- deleting in Cloud Control E.4.5
- editing in Cloud Control E.4.3
- Enterprise Management Cloud Control, managing in E.4.1
- Enterprise Manager Cloud Control, sensitive column types E.3
- Enterprise Manager Cloud Control, viewing in E.4.4
Oracle Data Redaction import operations
- inadvertently dropping policies 4.4.4
- ORA-28069 4.4.4
Oracle Data Redaction partial redaction
- creating policies for 3.8, 3.8.1
Oracle Data Redaction policies 3.5.3
- about 3.1
- altering 3.15.1
- building reports 3.18
- creating
  - examples 3.7.1.4
  - general syntax 3.3
  - procedure 3.4
- creating in Cloud Control E.5.2
- deleting in Cloud Control E.5.6
- disabling 3.16.1
- disabling in Cloud Control E.5.5
- dropping 3.17
- editing in Cloud Control E.5.3
- enabling 3.16.2
- Enterprise Manager Cloud Control, viewing in E.5.4
- exempting users from 3.13
- expressions
  - by Application Express session state 3.5.5
  - by database role 3.5.4
  - by OLS label dominance 3.5.6
  - by user environment 3.5.3
- filtering users
  - about 3.5.1
  - no filtering 3.5.7
- finding information about C
- Oracle Enterprise Manager Cloud Control E.5.6
- redacting multiple columns in one policy 3.14
- trace files B
Oracle Data Redaction policy expressions
- Cloud Control, about E.6.1
- creating in Cloud Control E.6.2
- deleting in Cloud Control E.6.5
- editing in Cloud Control E.6.3
- viewing in Cloud Control E.6.4
Oracle Enterprise Manager Cloud Control E.5.3
- creating custom formats E.4.2
- creating policy expressions E.6.2
- deleting policy expressions E.6.5
- disabling policies E.5.5
- editing policy expressions E.6.3
- Oracle Data Redaction E.4.2, E.4.3, E.5.5, E.6.1, E.6.2, E.6.3, E.6.4, E.6.5
- Oracle Data Redaction, creating policies E.5.2
- Oracle Data Redaction, viewing details of a policy E.5.4
- Oracle Data Redaction formats, viewing in E.4.4
- policy expressions, about E.6.1
- viewing policy expressions E.6.4
Oracle Enterprise Manager Data Masking and Subsetting Pack
- Oracle Data Redaction impact 4.8
Oracle Label Security
- functions using Data Redaction expressions 3.5.2.5
Oracle Virtual Private Database (VPD)
- Data Redaction 4.5
ORDER BY clause, Data Redaction policies 6.1

P

PDBs
- Data Redaction policies 1.5
policy expressions, Oracle Data Redaction 3.6.1

R

recycle bin
- Data Redaction policies and 5.1.2
REDACTION_COLUMNS data dictionary view
- invalid views 5.1.1
REDACTION_COLUMNS view C.1
REDACTION_EXPRESSIONS view C.2
REDACTION_POLICIES view C.3
REDACTION_VALUES_FOR_TYPE_FULL view C.4
reports
- based Data Redaction policies 3.18
returning null values
- about 2.6

S

SUBSTR function
- expressions 3.5.2.2
SYS_CONTEXT function
- Data Redaction policies 5.4
- SYS_SESSION_ROLES namespace used in Data Redaction 3.5.4
SYS_SESSION_ROLES SYS_CONTEXT namespace
- Data Redaction 3.5.4
SYSTEM user
- Data Redaction policies 5.3
SYS user
- Data Redaction policies 5.3

T

tutorials
- named Data Redaction policy expressions 3.6.5

U

UPDATE_FULL_REDACTION_VALUES Procedure D.5.9
UPDATE_POLICY_EXPRESSION Procedure D.5.10

V

views
- Data Redaction C
V public function (APEX_UTIL.GET_SESSION_STATE function), Data Redaction policies 3.5.5