Oracle | DBMS_RULEADM

Oracle DBMS_RULEADM_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

Constants

Name	Data Type	Value
General
KGLNRULS	BINARY_INTEGER	23
KGLNRULE	BINARY_INTEGER	36
KGLNREVC	BINARY_INTEGER	38

Dependencies

DBMS_AQADM_SYS	DBMS_RULE_ADM	DBMS_SYSTEM
DBMS_AQADM_SYSCALLS	DBMS_RULE_EXIMP	RE$NV_LIST
DBMS_AQ_SYS_IMP_INTERNAL	DBMS_RULE_IMP_OBJ	RE$TABLE_ALIAS_LIST
DBMS_CHAIN_INVOKER	DBMS_STREAMS_ADM_IVK	RE$VARIABLE_TYPE_LIST
DBMS_RULES_LIB

Documented No

Exceptions

Error Code	Reason

First Available Not known

Security Model Owned by SYS with EXECUTE granted to PUBLIC

Source {ORACLE_HOME}/rdbms/admin/dbmsread.sql
{ORACLE_HOME}/rdbms/admin/prvtread.plb

Subprograms

ADD_RULE	DROP_RULE	I_EVALUATION_CONTEXT_ADD_VAR
ALTER_EVALUATION_CONTEXT	DROP_RULE_SET	PATCH_RULE_PRIV
ALTER_RULE	I_ALTER_RULE	REGISTER_INTERNAL_ACTX
CREATE_EVALUATION_CONTEXT	I_CREATE_EVAL_CTX	REMOVE_RULE
CREATE_RULE	I_CREATE_RULE	UNREGISTER_INTERNAL_ACTX
CREATE_RULE_SET	I_CREATE_RULE_SET	VALIDATE_RE_OBJECT
DROP_EVALUATION_CONTEXT

ADD_RULE

Undocumented dbms_ruleadm_internal.add_rule( rule_name IN VARCHAR2, rule_set_name IN VARCHAR2, evaluation_context IN VARCHAR2 := NULL, rule_comment IN VARCHAR2 := NULL); PRAGMA SUPPLEMENTAL_LOG_DATA(add_rule, AUTO);

TBD

ALTER_EVALUATION_CONTEXT

Undocumented dbms_ruleadm_internal.alter_evaluation_context( evaluation_context_name IN VARCHAR2, table_aliases IN sys.re$table_alias_list := NULL, remove_table_aliases IN BOOLEAN := FALSE, variable_types IN sys.re$variable_type_list := NULL, remove_variable_types IN BOOLEAN := FALSE, evaluation_function IN VARCHAR2 := NULL, remove_evaluation_function IN BOOLEAN := FALSE, evaluation_context_comment IN VARCHAR2 := NULL, remove_eval_context_comment IN BOOLEAN := FALSE); PRAGMA SUPPLEMENTAL_LOG_DATA(alter_evaluation_context, AUTO);

TBD

ALTER_RULE

Undocumented dbms_ruleadm_internal.alter_rule( rule_name IN VARCHAR2, condition IN VARCHAR2 := NULL, evaluation_context IN VARCHAR2 := NULL, remove_evaluation_context IN BOOLEAN := FALSE, action_context IN sys.re$nv_list := NULL, remove_action_context IN BOOLEAN := FALSE, rule_comment IN VARCHAR2 := NULL, remove_rule_comment IN BOOLEAN := FALSE); PRAGMA SUPPLEMENTAL_LOG_DATA(alter_rule, AUTO);

TBD

CREATE_EVALUATION_CONTEXT

Undocumented dbms_ruleadm_internal.create_evaluation_context( evaluation_context_name IN VARCHAR2, table_aliases IN sys.re$table_alias_list := NULL, variable_types IN sys.re$variable_type_list := NULL, evaluation_function IN VARCHAR2 := NULL, evaluation_context_comment IN VARCHAR2 := NULL); PRAGMA SUPPLEMENTAL_LOG_DATA(CREATE_EVALUATION_CONTEXT, AUTO);

TBD

CREATE_RULE

Undocumented dbms_ruleadm_internal.create_rule( rule_name IN VARCHAR2, condition IN VARCHAR2, evaluation_context IN VARCHAR2 := NULL, action_context IN sys.re$nv_list := NULL, rule_comment IN VARCHAR2 := NULL); PRAGMA SUPPLEMENTAL_LOG_DATA(create_rule, AUTO);

TBD

CREATE_RULE_SET

Undocumented dbms_ruleadm_internal.create_rule_set( rule_set_name IN VARCHAR2, evaluation_context IN VARCHAR2 := NULL, rule_set_comment IN VARCHAR2 := NULL, result_cache IN BOOLEAN := FALSE); PRAGMA SUPPLEMENTAL_LOG_DATA(create_rule_set, AUTO);

TBD

DROP_EVALUATION_CONTEXT

Undocumented dbms_ruleadm_internal.drop_evaluation_context( evaluation_context_name IN VARCHAR2, force IN BOOLEAN := FALSE); PRAGMA SUPPLEMENTAL_LOG_DATA(drop_evaluation_context, AUTO);

TBD

DROP_RULE

Undocumented dbms_ruleadm_internal.drop_rule( rule_name IN VARCHAR2, force IN BOOLEAN := FALSE); PRAGMA SUPPLEMENTAL_LOG_DATA(drop_rule, AUTO);

TBD

DROP_RULE_SET

Undocumented dbms_ruleadm_internal.drop_rule_set( rule_set_name IN VARCHAR2, delete_rules IN BOOLEAN := FALSE); PRAGMA SUPPLEMENTAL_LOG_DATA(drop_rule_set, AUTO);

TBD

I_ALTER_RULE

Undocumented dbms_ruleadm_internal.i_alter_rule( rule_name IN VARCHAR2, condition IN VARCHAR2 := NULL, evaluation_context IN VARCHAR2 := NULL, remove_evaluation_context IN BOOLEAN := FALSE, action_context IN sys.re$nv_list := NULL, remove_action_context IN BOOLEAN := FALSE, rule_comment IN VARCHAR2 := NULL, remove_rule_comment IN BOOLEAN := FALSE, internal_actx_client IN VARCHAR2 := NULL, internal_action_context IN sys.re$nv_list := NULL, remove_int_actx IN BOOLEAN := FALSE);

TBD

I_CREATE_EVAL_CTX

Undocumented dbms_ruleadm_internal.i_create_eval_ctx( valuation_context_name IN VARCHAR2, table_aliases IN sys.re$table_alias_list := NULL, variable_types IN sys.re$variable_type_list := NULL, evaluation_function IN VARCHAR2 := NULL, evaluation_context_comment IN VARCHAR2 := NULL, eval_ctx_properties IN NUMBER := NULL);

TBD

I_CREATE_RULE

Undocumented dbms_ruleadm_internal.i_create_rule( rule_name IN VARCHAR2, condition IN VARCHAR2, evaluation_context IN VARCHAR2 := NULL, action_context IN sys.re$nv_list := NULL, rule_comment IN VARCHAR2 := NULL, rule_properties IN NUMBER := NULL, internal_actx_client IN VARCHAR2 := NULL, internal_action_context IN sys.re$nv_list := NULL);

TBD

I_CREATE_RULE_SET

Undocumented dbms_ruleadm_internal.i_create_rule_set( rule_set_name IN VARCHAR2, evaluation_context IN VARCHAR2 := NULL, rule_set_comment IN VARCHAR2 := NULL, rule_set_properties IN NUMBER := NULL, result_cache IN BOOLEAN := FALSE);

TBD

I_EVALUATION_CONTEXT_ADD_VAR

Undocumented dbms_ruleadm_internal.i_evaluation_context_add_var( evaluation_context_name IN VARCHAR2, variable_types IN sys.re$variable_type_list DEFAULT NULL);

TBD

PATCH_RULE_PRIV

Undocumented dbms_ruleadm_internal.patch_rule_priv( btab_schema IN VARCHAR2, btab_name IN VARCHAR2, condition IN VARCHAR2);

TBD

REGISTER_INTERNAL_ACTX

Undocumented dbms_ruleadm_internal.register_internal_actx( client_name IN VARCHAR2, export_function IN VARCHAR2 DEFAULT NULL, client_comment IN VARCHAR2 DEFAULT NULL);

TBD

REMOVE_RULE

Undocumented dbms_ruleadm_internal.remove_rule( rule_name IN VARCHAR2, rule_set_name IN VARCHAR2, evaluation_context IN VARCHAR2 := NULL, all_evaluation_contexts IN BOOLEAN := FALSE); PRAGMA SUPPLEMENTAL_LOG_DATA(remove_rule, AUTO);

TBD

UNREGISTER_INTERNAL_ACTX

Undocumented dbms_ruleadm_internal.unregister_internal_actx(client_name IN VARCHAR2);

TBD

VALIDATE_RE_OBJECT

Undocumented dbms_ruleadm_internal.validate_re_object( object_name IN VARCHAR2, object_namespace IN BINARY_INTEGER);

TBD