 |
|
Oracle Tips by Burleson |
Chapter 2 -
Configuring Oracle Job Scheduling
Setting up a Test
Environment
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;
conn job_user/job_user
|
Download your Oracle scripts now:
www.oracle-script.com
The
definitive Oracle Script collection for every Oracle professional DBA
|
|
