- Mastering Oracle Scheduler in Oracle 11g Databases
- Ronald Rood
- 202字
- 2021-04-01 14:12:52
Creating a user
When working with simple jobs, our basic need is to create a user. In DB Console, there is a default user sysman
. We can use this or the user system
. However, it is better to create a dedicated user for different tasks. This prevents us from giving too many privileges to jobs and maintains auditability. So, let's first create a normal user who does the work for us:
create user marvin identified by panic; grant create session, create job to marvin; grant select any dictionary to marvin; create user stats identified by nopanic; alter user stats quota unlimited on users; create table stats.session_log as select * from v$session where 1 = 2; create table stats.session_stat_log as select * from v$mystat where 1 = 2; grant select,insert,update,delete on stats.session_log to marvin; grant select,insert,update,delete on stats.session_stat_log to marvin; create public synonym session_log for stats.session_log; create public synonym session_stat_log for stats.session_stat_log;
The select any dictionary
privilege is mainly because we want to use DB Console. For this, it must view a lot from the dictionary. Now start a web browser and connect to the freshly created user marvin
. The Oracle Scheduler support is provided in the Server tab of the DB Console.
推薦閱讀
- 突破平面Photoshop UI界面設(shè)計(jì)與制作剖析
- PrestaShop 1.3 Theming – Beginner’s Guide
- 從零開始:AutoCAD 2015中文版機(jī)械制圖基礎(chǔ)培訓(xùn)教程
- Hi!扁平化Photoshop扁平化用戶界面設(shè)計(jì)教程
- 改變思維:菜鳥也能做出震撼PPT(全彩版)
- Learning Facebook Application Development
- Photoshop CS6中文版基礎(chǔ)培訓(xùn)教程
- 跟儲(chǔ)君老師學(xué)Excel極簡(jiǎn)思維
- Adobe創(chuàng)意大學(xué)Illustrator CS5 產(chǎn)品專家認(rèn)證標(biāo)準(zhǔn)教材
- Adobe創(chuàng)意大學(xué)Photoshop CS5 產(chǎn)品專家認(rèn)證標(biāo)準(zhǔn)教材
- ASP.NET 3.5 Social Networking
- Backbone.js Cookbook
- Microsoft Azure: Enterprise Application Development
- Photoshop & Illustrator平面設(shè)計(jì)火星課堂
- After Effects 影視后期特效:短視頻制作實(shí)戰(zhàn)寶典