Oracle | DBMS_RULE_EXP_EC

Oracle DBMS_RULE_EXP_EC_INTERNAL Version 23c

General Information

Library Note

Morgan's Library Page Header

ACE Director Alum Daniel Morgan, founder of Morgan's Library, is scheduling complimentary technical Workshops on Database Security for the first 30 Oracle Database customers located anywhere in North America, EMEA, LATAM, or APAC that send an email to asra_us@oracle.com. Request a Workshop for your organization today.

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