Oracle | DBMS_RULE_EXP_EC

Oracle DBMS_RULE_EXP_EC_INTERNAL 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 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

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);