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
DEFINER
Dependencies
DBMS_LOB
DBMS_ZHELP
REC_VAR$
DBMS_RULE_EXP_EV_CTXS
OBJ$
RULE_EC$
DBMS_RULE_EXP_UTL
REC_TAB$
USER$
DBMS_SYS_ERROR
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_ec_internal.i_create_exp(
objid IN NUMBER,
new_block OUT BINARY_INTEGER)
RETURN VARCHAR2;
TBD
I_GRANT_EXP
Undocumented
dbms_rule_exp_ec_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_ec_internal.i_grant_sysprivs_exp(
new_block OUT BINARY_INTEGER)
RETURN VARCHAR2;
DECLARE
retVal VARCHAR2(128);
outVal BINARY_INTEGER;
BEGIN
retVal := dbms_rule_exp_ec_internal.i_grant_sysprivs_exp (outVal);
dbms_output.put_line(TO_CHAR(retVal));
dbms_output.put_line(outVal);
END;
/
SYS.DBMS_RULE_ADM.GRANT_SYSTEM_PRIVILEGE(SYS.DBMS_RULE_ADM.CREATE_EVALUATION_CONTEXT_OBJ, '"AQ_ADMINISTRATOR_ROLE"',TRUE);