Oracle | OWA

Oracle OWA_MATCH Version 21c

General Information

Library Note

Morgan's Library Page Header

Which has the higher priority in your organization: Deploying a new database or securing the ones you already have? Looking for a website, and resources, dedicated solely to securing Oracle databases? Check out DBSecWorx.

Purpose for use with the Oracle Web Agent

AUTHID DEFINER

Data Types empty_vc_arr owa_util.vc_arr;

Dependencies

OWA_PATTERN

OWA_UTIL

PLITBLM

Documented No

First Available 2004

Security Model Owned by SYS with EXECUTE granted to PUBLIC

Source {ORACLE_HOME}/rdbms/admin/pubmat.sql
{ORACLE_HOME}/rdbms/admin/privmat.sql

MATCH_PATTERN

Pattern matches against owa_match.match_pattern( p_string IN VARCHAR2, p_simple_pattern IN owa_util.vc_arr DEFAULT empty_vc_arr, p_complex_pattern IN owa_util.vc_arr DEFAULT empty_vc_arr, p_use_special_chars IN BOOLEAN DEFAULT TRUE) RETURN BOOLEAN;

DECLARE

       sPattern owa_util.vc_arr;

       cPattern owa_util.vc_arr;

      BEGIN

       
      sPattern(1) := 'sys.%';

       
      sPattern(2) := 'dbms\_%';

       
      sPattern(3) := 'utl\_%';

       
      sPattern(4) := 'owa\_%';

       
      sPattern(5) := 'owa.%';

       
      sPattern(6) := 'htp.%';

       
      sPattern(7) := 'htf.%';

      

        IF ((owa_match.match_pattern('test', sPattern, cPattern, TRUE))) THEN

          dbms_output.put_line('T');

        ELSE

          dbms_output.put_line('F');

        END IF;

      

       
      IF ((owa_match.match_pattern('sys.%', sPattern, cPattern, TRUE))) THEN

          dbms_output.put_line('T');

        ELSE

          dbms_output.put_line('F');

        END IF;

      END;

      /

      F

      T