- 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.
- Protel DXP 2004 SP2原理圖與PCB設(shè)計(jì)(第4版)
- Python 2.6 Graphics Cookbook
- Flash CC動(dòng)畫(huà)制作案例教程
- iPhone Applications Tune/Up
- 邊做邊學(xué):平面廣告設(shè)計(jì)與制作(Photoshop 2020+Illustrator 2020·第3版·微課版)
- CorelDRAW 2020中文版入門(mén)、精通與實(shí)戰(zhàn)
- Photoshop CS6標(biāo)準(zhǔn)教程(全視頻微課版)
- 中文版3ds Max/VRay效果圖制作完全自學(xué)教程(實(shí)例培訓(xùn)教材版)
- Word-Excel-PowerPoint 2010三合一辦公應(yīng)用實(shí)戰(zhàn)從入門(mén)到精通(超值版)
- Oracle Fusion Middleware Patterns
- Photoshop CC2017圖像處理實(shí)例教程
- 巧用ChatGPT高效搞定Excel數(shù)據(jù)分析
- MooTools 1.2 Beginner's Guide
- Microsoft SQL Server 2008 High Availability
- 從零開(kāi)始:Dreamweaver CS6中文版基礎(chǔ)培訓(xùn)教程