Chapter 2 -
Configuring Oracle Job Scheduling
||Oracle Tips by Burleson
Setting up a Test
conn sys/password as sysdba
-- Create user.
create user job_user identified by job_user
default tablespace users quota
unlimited on users;
grant connect to job_user;
grant select_catalog_role to job_user;
-- Privileges for task, not for dbms_job.
grant create procedure to job_user;
grant execute on dbms_lock to job_user;
grant execute on dbms_system to job_user;
-- Oracle 10g only.
grant create job to job_user;
grant manage scheduler to job_user;
Download your Oracle scripts now:
definitive Oracle Script collection for every Oracle professional DBA
Copyright © 1996 - 2014 by
Burleson. All rights reserved.
Oracle® is the registered trademark
of Oracle Corporation.