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.