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