Oracle | DBMS_REDACTOR

Oracle DBMS_REDACTOR Version 23c

General Information

Library Note

Morgan's Library Page Header

ACE Director Alum Daniel Morgan, founder of Morgan's Library, is scheduling complimentary technical Workshops on Database Security for the first 30 Oracle Database customers located anywhere in North America, EMEA, LATAM, or APAC that send an email to asra_us@oracle.com. Request a Workshop for your organization today.

Purpose Data Redaction support

AUTHID DEFINER

Dependencies

DBMS_REDACTOR_LIB

Documented No

Exceptions

Error Code	Reason

First Available 23.1 Beta

Security Model Owned by SYS with EXECUTE granted to the EXECUTE_CATALOG_ROLE role.

Source {ORACLE_HOME}/rdbms/admin/prvtredact.plb

Subprograms

REDACT

REDACT (new 23c)

Returns the redaction pattern consisting of non string and numeric characters dbms_redactor.redact( instring IN VARCHAR2, outstring OUT VARCHAR2, hints_are_comment IN BOOLEAN, only_length IN BOOLEAN, character_set IN BOOLEAN) RETURN BINARY_INTEGER;

DECLARE

 outVal dbms_id;

 retVal BINARY_INTEGER;

      BEGIN

  retVal := dbms_redactor.redact('4567-1234-5678-9012', 
      outVal, TRUE, TRUE, TRUE);

  dbms_output.put_line(outVal);

  dbms_output.put_line(retVal);

      END;

      /

      (*) *-*

      6

      

      DECLARE

 outVal dbms_id;

 retVal BINARY_INTEGER;

      BEGIN

  retVal := dbms_redactor.redact('4567-1234-5678-9012', 
      outVal, TRUE, TRUE, TRUE);

  dbms_output.put_line(outVal);

  dbms_output.put_line(retVal);

      END;

      /

      *-*-*-*

      7

      

      PL/SQL procedure successfully completed.

      DECLARE

 outVal dbms_id;

 retVal BINARY_INTEGER;

      BEGIN

  retVal := dbms_redactor.redact('4567-1234-5678-9012', 
      outVal, TRUE, TRUE, TRUE);

  dbms_output.put_line(outVal);

  dbms_output.put_line(retVal);

      END;

      /

      7

      

      PL/SQL procedure successfully completed.