官术网_书友最值得收藏!

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.

主站蜘蛛池模板: 蒙城县| 务川| 横峰县| 葫芦岛市| 永州市| 常山县| 嘉祥县| 嘉义市| 仪陇县| 文成县| 玉龙| 娱乐| 桐柏县| 三江| 虹口区| 瑞丽市| 台东县| 偏关县| 罗山县| 舟山市| 佛山市| 安丘市| 柯坪县| 开封市| 德惠市| 霍山县| 通榆县| 太湖县| 竹山县| 博湖县| 桑日县| 上高县| 宁南县| 灌南县| 克拉玛依市| 陇川县| 克东县| 永胜县| 兴义市| 巴林左旗| 揭东县|