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