[Home] [Help]
PACKAGE: SYS.DBMS_RULE_ADM
Source
1 PACKAGE dbms_rule_adm AUTHID CURRENT_USER AS
2
3 --------------------
4 -- PUBLIC CONSTANT
5 --
6 -- privilege code for rule engine objects
7
8 -- system privileges
9 CREATE_EVALUATION_CONTEXT_OBJ CONSTANT BINARY_INTEGER := 1;
10 CREATE_ANY_EVALUATION_CONTEXT CONSTANT BINARY_INTEGER := 2;
11 ALTER_ANY_EVALUATION_CONTEXT CONSTANT BINARY_INTEGER := 3;
12 DROP_ANY_EVALUATION_CONTEXT CONSTANT BINARY_INTEGER := 4;
13 EXECUTE_ANY_EVALUATION_CONTEXT CONSTANT BINARY_INTEGER := 5;
14
15 CREATE_RULE_SET_OBJ CONSTANT BINARY_INTEGER := 6;
16 CREATE_ANY_RULE_SET CONSTANT BINARY_INTEGER := 7;
17 ALTER_ANY_RULE_SET CONSTANT BINARY_INTEGER := 8;
18 DROP_ANY_RULE_SET CONSTANT BINARY_INTEGER := 9;
19 EXECUTE_ANY_RULE_SET CONSTANT BINARY_INTEGER := 10;
20
21 CREATE_RULE_OBJ CONSTANT BINARY_INTEGER := 11;
22 CREATE_ANY_RULE CONSTANT BINARY_INTEGER := 12;
23 ALTER_ANY_RULE CONSTANT BINARY_INTEGER := 13;
24 DROP_ANY_RULE CONSTANT BINARY_INTEGER := 14;
25 EXECUTE_ANY_RULE CONSTANT BINARY_INTEGER := 15;
26
27 -- object privileges
28 EXECUTE_ON_EVALUATION_CONTEXT CONSTANT BINARY_INTEGER := 16;
29 ALTER_ON_EVALUATION_CONTEXT CONSTANT BINARY_INTEGER := 17;
30 ALL_ON_EVALUATION_CONTEXT CONSTANT BINARY_INTEGER := 18;
31
32 EXECUTE_ON_RULE_SET CONSTANT BINARY_INTEGER := 19;
33 ALTER_ON_RULE_SET CONSTANT BINARY_INTEGER := 20;
34 ALL_ON_RULE_SET CONSTANT BINARY_INTEGER := 21;
35
36 EXECUTE_ON_RULE CONSTANT BINARY_INTEGER := 22;
37 ALTER_ON_RULE CONSTANT BINARY_INTEGER := 23;
38 ALL_ON_RULE CONSTANT BINARY_INTEGER := 24;
39
40 -- return codes for evaluation_function associated with an evaluation
41 -- context
42 -- These codes are interpreted as follows:
43 -- EVALUATION_SUCCESS: evaluation completed successfully
44 -- EVALUATION_FAILURE: evaluation failed due to errors
45 -- EVALUATION_CONTINUE: continue default evaluation of the rule set
46
47 EVALUATION_SUCCESS CONSTANT BINARY_INTEGER := 0;
48 EVALUATION_FAILURE CONSTANT BINARY_INTEGER := 1;
49 EVALUATION_CONTINUE CONSTANT BINARY_INTEGER := 2;
50
51 -- named exceptions
52 INVALID_NV_NAME EXCEPTION;
53 PRAGMA exception_init(INVALID_NV_NAME, -24161);
54
55 PROCEDURE create_evaluation_context(
56 evaluation_context_name IN varchar2,
57 table_aliases IN sys.re$table_alias_list := NULL,
58 variable_types IN sys.re$variable_type_list := NULL,
59 evaluation_function IN varchar2 := NULL,
60 evaluation_context_comment IN varchar2 := NULL);
61
62 PROCEDURE create_evaluation_context_int(
63 evaluation_context_name IN varchar2,
64 table_aliases IN sys.re$table_alias_list := NULL,
65 variable_types IN sys.re$variable_type_list := NULL,
66 evaluation_function IN varchar2 := NULL,
67 evaluation_context_comment IN varchar2 := NULL);
68 PRAGMA SUPPLEMENTAL_LOG_DATA(create_evaluation_context_int, AUTO);
69
70 PROCEDURE alter_evaluation_context(
71 evaluation_context_name IN varchar2,
72 table_aliases IN sys.re$table_alias_list := NULL,
73 remove_table_aliases IN boolean := FALSE,
74 variable_types IN sys.re$variable_type_list := NULL,
75 remove_variable_types IN boolean := FALSE,
76 evaluation_function IN varchar2 := NULL,
77 remove_evaluation_function IN boolean := FALSE,
78 evaluation_context_comment IN varchar2 := NULL,
79 remove_eval_context_comment IN boolean := FALSE);
80
81 PROCEDURE alter_evaluation_context_int(
82 evaluation_context_name IN varchar2,
83 table_aliases IN sys.re$table_alias_list := NULL,
84 remove_table_aliases IN boolean := FALSE,
85 variable_types IN sys.re$variable_type_list := NULL,
86 remove_variable_types IN boolean := FALSE,
87 evaluation_function IN varchar2 := NULL,
88 remove_evaluation_function IN boolean := FALSE,
89 evaluation_context_comment IN varchar2 := NULL,
90 remove_eval_context_comment IN boolean := FALSE);
91 PRAGMA SUPPLEMENTAL_LOG_DATA(alter_evaluation_context, AUTO);
92
93 PROCEDURE drop_evaluation_context(
94 evaluation_context_name IN varchar2,
95 force IN boolean := FALSE);
96
97 PROCEDURE drop_evaluation_context_int(
98 evaluation_context_name IN varchar2,
99 force IN boolean := FALSE);
100 PRAGMA SUPPLEMENTAL_LOG_DATA(drop_evaluation_context_int, AUTO);
101
102 PROCEDURE create_rule_set(
103 rule_set_name IN varchar2,
104 evaluation_context IN varchar2 := NULL,
105 rule_set_comment IN varchar2 := NULL,
106 result_cache IN boolean := FALSE);
107
108 PROCEDURE create_rule_set_int(
109 rule_set_name IN varchar2,
110 evaluation_context IN varchar2 := NULL,
111 rule_set_comment IN varchar2 := NULL,
112 result_cache IN boolean := FALSE);
113 PRAGMA SUPPLEMENTAL_LOG_DATA(create_rule_set_int, AUTO);
114
115 PROCEDURE drop_rule_set(
116 rule_set_name IN varchar2,
117 delete_rules IN boolean := FALSE);
118
119 PROCEDURE drop_rule_set_int(
120 rule_set_name IN varchar2,
121 delete_rules IN boolean := FALSE);
122 PRAGMA SUPPLEMENTAL_LOG_DATA(drop_rule_set_int, AUTO);
123
124 PROCEDURE create_rule(
125 rule_name IN varchar2,
126 condition IN varchar2,
127 evaluation_context IN varchar2 := NULL,
128 action_context IN sys.re$nv_list := NULL,
129 rule_comment IN varchar2 := NULL);
130
131 PROCEDURE create_rule_int(
132 rule_name IN varchar2,
133 condition IN varchar2,
134 evaluation_context IN varchar2 := NULL,
135 action_context IN sys.re$nv_list := NULL,
136 rule_comment IN varchar2 := NULL);
137 PRAGMA SUPPLEMENTAL_LOG_DATA(create_rule_int, AUTO);
138
139 PROCEDURE alter_rule(
140 rule_name IN varchar2,
141 condition IN varchar2 := NULL,
142 evaluation_context IN varchar2 := NULL,
143 remove_evaluation_context IN boolean := FALSE,
144 action_context IN sys.re$nv_list := NULL,
145 remove_action_context IN boolean := FALSE,
146 rule_comment IN varchar2 := NULL,
147 remove_rule_comment IN boolean := FALSE);
148
149 PROCEDURE alter_rule_int(
150 rule_name IN varchar2,
151 condition IN varchar2 := NULL,
152 evaluation_context IN varchar2 := NULL,
153 remove_evaluation_context IN boolean := FALSE,
154 action_context IN sys.re$nv_list := NULL,
155 remove_action_context IN boolean := FALSE,
156 rule_comment IN varchar2 := NULL,
157 remove_rule_comment IN boolean := FALSE);
158 PRAGMA SUPPLEMENTAL_LOG_DATA(alter_rule_int, AUTO);
159
160 PROCEDURE drop_rule(
161 rule_name IN varchar2,
162 force IN boolean := FALSE);
163
164 PROCEDURE drop_rule_int(
165 rule_name IN varchar2,
166 force IN boolean := FALSE);
167 PRAGMA SUPPLEMENTAL_LOG_DATA(drop_rule_int, AUTO);
168
169 PROCEDURE add_rule(
170 rule_name IN varchar2,
171 rule_set_name IN varchar2,
172 evaluation_context IN varchar2 := NULL,
173 rule_comment IN varchar2 := NULL);
174
175 PROCEDURE add_rule_int(
176 rule_name IN varchar2,
177 rule_set_name IN varchar2,
178 evaluation_context IN varchar2 := NULL,
179 rule_comment IN varchar2 := NULL);
180 PRAGMA SUPPLEMENTAL_LOG_DATA(add_rule_int, AUTO);
181
182 PROCEDURE remove_rule(
183 rule_name IN varchar2,
184 rule_set_name IN varchar2,
185 evaluation_context IN varchar2 := NULL,
186 all_evaluation_contexts IN boolean := FALSE);
187
188 PROCEDURE remove_rule_int(
189 rule_name IN varchar2,
190 rule_set_name IN varchar2,
191 evaluation_context IN varchar2 := NULL,
192 all_evaluation_contexts IN boolean := FALSE);
193 PRAGMA SUPPLEMENTAL_LOG_DATA(remove_rule_int, AUTO);
194
195 PROCEDURE grant_system_privilege(
196 privilege IN binary_integer,
197 grantee IN varchar2,
198 grant_option IN boolean := FALSE);
199 PRAGMA SUPPLEMENTAL_LOG_DATA(grant_system_privilege, AUTO);
200
201 PROCEDURE revoke_system_privilege(
202 privilege IN binary_integer,
203 revokee IN varchar2);
204 PRAGMA SUPPLEMENTAL_LOG_DATA(revoke_system_privilege, AUTO);
205
206 PROCEDURE grant_object_privilege(
207 privilege IN binary_integer,
208 object_name IN varchar2,
209 grantee IN varchar2,
210 grant_option IN boolean := FALSE);
211 PRAGMA SUPPLEMENTAL_LOG_DATA(grant_object_privilege, AUTO);
212
213 PROCEDURE revoke_object_privilege(
214 privilege IN binary_integer,
215 object_name IN varchar2,
216 revokee IN varchar2);
217 PRAGMA SUPPLEMENTAL_LOG_DATA(revoke_object_privilege, AUTO);
218
219 END dbms_rule_adm;