Oracle | DBMS_RULE_EXP_RS

Oracle DBMS_RULE_EXP_RS_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_RULE_EXP_RULE_SETS	NOEXP$	RULE_MAP$
DBMS_RULE_EXP_UTL	OBJ$	RULE_SET$
DBMS_SYS_ERROR	RULE$	USER$
DBMS_ZHELP

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_rs_internal.i_create_exp( objid IN NUMBER, new_block OUT BINARY_INTEGER) RETURN VARCHAR2;

TBD

I_GRANT_EXP

Undocumented dbms_rule_exp_rs_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_rs_internal.i_grant_sysprivs_exp(new_block OUT BINARY_INTEGER) RETURN VARCHAR2;

DECLARE

       retVal VARCHAR2(128);

       outVal BINARY_INTEGER;

      BEGIN

        retVal := dbms_rule_exp_rs_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_RULE_SET_OBJ, 
      '"AQ_ADMINISTRATOR_ROLE"',TRUE);