Oracle | DBMS_RULE_EXP_RL

Oracle DBMS_RULE_EXP_RL_INTERNAL Version 21c

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 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	I_GRANT_SYSPRIVS_EXP	I_SCHEMA_CALLOUT
I_GRANT_EXP	I_INSTANCE_CALLOUT

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.