Oracle | DBMS_RULE_EXP_RL

Oracle DBMS_RULE_EXP_RL_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 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.