Oracle 12c Data Redaction
DATA REDACTION ( 12c New Features) ---------------------------------- Oracle Data Redaction adds the ability to change the output from sql query field values (in full or in part), depending on conditions. DBMS_REDACT package managed the Data Redaction. create the redaction user: -------------------------- create user redact_user identified by oracle; User created. Grant appropriate privileges to manage redaction policies: ---------------------------------------------------------- grant connect, resource, unlimited tablespace to redact_user; grant select on Sys.redaction_policies to redact_user; grant select on Sys.redaction_columns to redact_user; grant execute on dbms_redact to redact_user; Grant succeeded. SQL> Grant succeeded. SQL> Grant succeeded. SQL> Grant succeeded. Create a test table redtest ----------------------------- SQL> conn / as sysdba Connected. SQL> grant select on hr...