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
Undocumented
AUTHID
CURRENT_USER
Dependencies
ANYDATA
DBMS_RULE_EXP_UTL
PLITBLM
DBA_RULES
DBMS_SYS_ERROR
RE$NAME_ARRAY
DBA_TABLES
DBMS_ZHELP
RE$NV_LIST
DBMS_ASSERT
EXPDEPOBJ$
RULE$
DBMS_LOB
NOEXP$
RULE_SET_IEUAC$
DBMS_RULES_LIB
OBJ$
USER$
DBMS_RULE_EXP_RULES
Documented
No
First Available
Not Known
Security Model
Owned by SYS with no privileges granted.
Source
{ORACLE_HOME}/rdbms/admin/prvtreut.plb
Subprograms
I_CREATE_EXP
Undocumented
dbms_rule_exp_rl_internal.i_create_exp(
OBJID IN NUMBER,
NEW_BLOCK OUT BINARY_INTEGER)
RETURN VARCHAR2;
TBD
I_GRANT_EXP
Undocumented
dbms_rule_exp_rl_internal.i_grant_exp(
OBJID IN NUMBER,
ISDBA IN BINARY_INTEGER,
GRANTOR OUT VARCHAR2,
NEW_BLOCK OUT BINARY_INTEGER)
RETURN VARCHAR2;
TBD
I_GRANT_SYSPRIVS_EXP
Undocumented
dbms_rule_exp_rl_internal.i_grant_sysprivs_exp(NEW_BLOCK OUT BINARY_INTEGER)
RETURN VARCHAR2;
DECLARE
outVal BINARY_INTEGER;
retVal dbms_id;
BEGIN
retVal := dbms_rule_exp_rl_internal.i_grant_sysprivs_exp (outVal);
dbms_output.put_line('Out: ' || TO_CHAR(outVal));
dbms_output.put_line(retVal);
END;
/
Out:
SYS.DBMS_RULE_ADM.GRANT_SYSTEM_PRIVILEGE(SYS.DBMS_RULE_ADM.CREATE_RULE_OBJ, '"AQ_ADMINISTRATOR_ROLE"',TRUE);
I_INSTANCE_CALLOUT
Undocumented
dbms_rule_exp_rl_internal.i_instance_callout(
NAME IN VARCHAR2
SCHEMA IN VARCHAR2
PREPOST IN BINARY_INTEGER);
exec dbms_rule_exp_rl_internal.i_instance_callout ('TEST', 'UWCLASS', 1);
PL/SQL procedure successfully completed.
I_SCHEMA_CALLOUT
Undocumented
dbms_rule_exp_rl_internal.i_schema_callout(
SCHEMA IN VARCHAR2,
PREPOST IN BINARY_INTEGER);
exec dbms_rule_exp_rl_internal.i_schema_callout ('UWCLASS', 1);
PL/SQL procedure successfully completed.