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
Rule Export Utilities
AUTHID
DEFINER
Dependencies
DBMS_ASSERT
DBMS_RULE_EXP_RS_INTERNAL
KU$_STATUS
DBMS_DATAPUMP
DBMS_RULE_EXP_RULES
OBJ$
DBMS_RULE_EXP_EC_INTERNAL
DBMS_RULE_EXP_RULE_SETS
USER$
DBMS_RULE_EXP_EV_CTXS
DBMS_SUM_RWEQ_EXPORT
V$DATABASE
DBMS_RULE_EXP_RL_INTERNAL
KU$_JOBSTATUS1220
Documented
No
First Available
Not known
Security Model
Owned by SYS with no privileges granted
Source
{ORACLE_HOME}/rdbms/admin/prvtreut.plb
Subprograms
ENQUOTE_LITERAL
Double quotes a string literal
dbms_rule_exp_utl.enquote_literal(str IN VARCHAR2) RETURN VARCHAR2;
Makes a call to DBMS_ASSERT ENQUOTE_LITERAL
ENQUOTE_NAME
Double quotes a valid object name
dbms_rule_exp_utl.enquote_name(str IN VARCHAR2) RETURN VARCHAR2;
Makes a call to DBMS_ASSERT ENQUOTE_NAME
EXPORT_ACTION
Undocumented
dbms_rule_exp_utl.export_action RETURN BOOLEAN;
BEGIN
IF dbms_rule_exp_utl.export_action THEN
dbms_output.put_line('T');
ELSE
dbms_output.put_line('F');
END IF;
END;
/
T
PL/SQL procedure successfully completed.
IS_SYSTEM_EXPORT
Undocumented
dbms_rule_exp_utl.is_system_export RETURN BOOLEAN;
BEGIN
IF dbms_rule_exp_utl.is_system_export THEN
dbms_output.put_line('T');
ELSE
dbms_output.put_line('F');
END IF;
END;
/
F
PL/SQL procedure successfully completed.
OBJECT_OWNER
Undocumented
dbms_rule_exp_utl.object_owner(
obj_id IN NUMBER,
obj_owner OUT VARCHAR2);
DECLARE
outVal dbms_id;
BEGIN
dbms_rule_exp_utl.object_owner (18, outVal);
dbms_output.put_line(outVal);
END;
/
SYS
PL/SQL procedure successfully completed.
PARSE_NAME
Undocumented
dbms_rule_exp_utl.parse_name(
full_name IN VARCHAR2,
obsch IN VARCHAR2)
RETURN VARCHAR2;
SELECT dbms_rule_exp_utl.parse_name ('sys.obj$', NULL)
FROM dual;
DBMS_RULE_EXP_UTL.PARSE_NAME('SYS.OBJ$',NULL)
----------------------------------------------
SYS.OBJ$