- Mastering Oracle Scheduler in Oracle 11g Databases
- Ronald Rood
- 249字
- 2021-04-01 14:12:55
Privileges
Before we can go any further, we need some extra privileges. These privileges will come along with the CREATE JOB
privilege that we saw in the previous chapter. We need to be able to create rule sets, rules, and evaluation contexts. We can do this by using the DBMS_RULE_ADM
package to grant the user, MARVIN
, the required privileges:
--/ BEGIN DBMS_RULE_ADM.GRANT_SYSTEM_PRIVILEGE (DBMS_RULE_ADM.CREATE_RULE_OBJ, 'MARVIN'); DBMS_RULE_ADM.GRANT_SYSTEM_PRIVILEGE (DBMS_RULE_ADM.CREATE_RULE_SET_OBJ, 'MARVIN'); DBMS_RULE_ADM.GRANT_SYSTEM_PRIVILEGE (DBMS_RULE_ADM.CREATE_EVALUATION_CONTEXT_OBJ, 'MARVIN'); END; /
This tiny bit of code gives MARVIN
the privileges to create rule sets, rules, and evaluation contexts.
We discussed earlier in the chapter what a rule is. A rule set, on the other hand, is a collection of the rules that control the chain. Mostly, we will not deal with rule sets as individual items and we will not even need to assign a name to them (but we could do so if we wanted). Normally, the names of rule sets and rules are generated by the system. We can even reuse a carefully defined rule set that relates to another chain. This chain would contain the exact set of steps, or rule set, as the original chain. Having said that, most of the time we will be happy with the system generated names. We will hardly ever refer to a rule set by name when using the Scheduler. Often, we will build new chains with custom rules for that chain. In rare cases, we can define the chain rules and the chain steps separately if needed.
- Adobe After Effects CC 高手之路
- Photoshop圖形圖像設計案例教程(高等院校計算機任務驅動教改教材)
- Adobe Illustrator 2023基礎教材
- Microsoft BizTalk Server 2010 Patterns
- Adobe創意大學Illustrator產品專家認證標準教材(CS6修訂版)
- 深入理解OpenCV:實用計算機視覺項目解析(原書第3版)
- Instant Testing with QUnit
- Photoshop移動UI設計從入門到精通
- 神奇的中文版Photoshop CC 2017入門書
- Cacti 0.8 Network Monitoring
- Adobe創意大學Premiere Pro CS5 影視剪輯師標準實訓教材
- Photoshop CG 古風插畫繪制技法精解
- VMware Virtual SAN實戰
- 選擇的藝術:Photoshop圖像處理深度剖析(第3版)
- AutoCAD 2016中文版自學視頻教程(標準版)