• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 726
  • Last Modified:

Priviledges for DBMS Scheduler

I'm trying to assign priviledges to a user for the DBMS Scheduler.

I want to give them rights to create their own schedules on their schema and only their own schema. Is there a way to do this?

I'm using the Oracle Enterprise Manager to perform this work.

Thank you
0
lulubell-b
Asked:
lulubell-b
  • 4
  • 3
1 Solution
 
slightwv (䄆 Netminder) Commented:
0
 
Naveen KumarProduction Manager / Application Support ManagerCommented:
GRANT CREATE JOB to <<user>> should be fine to setup a basic job through dbms_scheduler.

if you want to specifically work with schedules, job chains , etc then this privilege should also be there.

grant MANAGE SCHEDULER to <<user>>;

what are you trying to do ? can you explain with an example.
0
 
lulubell-bAuthor Commented:
I'm trying to grant privileges to a user to create jobs and schedule them in his own schema. I dont want to have to rely on the SYS to perform this task. I also want his user attached to him when he performs these tasks.
0
The new generation of project management tools

With monday.com’s project management tool, you can see what everyone on your team is working in a single glance. Its intuitive dashboards are customizable, so you can create systems that work for you.

 
slightwv (䄆 Netminder) Commented:
OK.  Does the above information not give you the information you need?

The first link I posted has a very nice table on the specific privileges and what they are used for.
0
 
lulubell-bAuthor Commented:
Okay, still unsure if the user has the correct privileges. I think he does though. Do you know of any links to a Enterprise Manager Guide? I have a couple more questions, Do you know the differences between Default Tablespace and Temporary Tablespace?

Also, when creating a job/schedule in SQL PLUS is the below code correct?

Do I create create the job first then the schedule? I'm A little confused on the order and some of the examples.

Thanks

dbms_scheduler.create_job(
job_name            IN VARCHAR2,
job_type            IN VARCHAR2,
job_action          IN VARCHAR2,
number_of_arguments IN PLS_INTEGER DEFAULT 0,
start_date          IN TIMESTAMP WITH TIME ZONE DEFAULT NULL,
repeat_interval     IN VARCHAR2    DEFAULT NULL,
end_date            IN TIMESTAMP WITH TIME ZONE DEFAULT NULL,
job_class           IN VARCHAR2    DEFAULT 'DEFAULT_JOB_CLASS',
enabled             IN BOOLEAN     DEFAULT FALSE,
auto_drop           IN BOOLEAN     DEFAULT TRUE,
comments            IN VARCHAR2    DEFAULT NULL);

---
dbms_scheduler.create_schedule(
schedule_name   IN VARCHAR2,
start_date      IN TIMESTAMP WITH TIMEZONE DEFAULT NULL,
repeat_interval IN VARCHAR2,
end_date        IN TIMESTAMP WITH TIMEZONE DEFAULT NULL,
comments        IN VARCHAR2 DEFAULT NULL);

BEGIN
  dbms_scheduler.create_schedule('embed_sched', repeat_interval =>
  'FREQ=YEARLY;BYDATE=0130,0220,0725');

  dbms_scheduler.create_schedule('main_sched', repeat_interval => 'FREQ=MONTHLY;INTERVAL=2;BYMONTHDAY=15;BYHOUR=9,17;INCLUDE=embed_sched'); END;
/
0
 
slightwv (䄆 Netminder) Commented:
>>Do you know of any links to a Enterprise Manager Guide?

All Oracle documentation can be found online at: otn.oracle.com.

>>I have a couple more questions, Do you know the differences between Default Tablespace and Temporary Tablespace?

This needs to be asked as a separate question.

>>Do I create create the job first then the schedule?

From the docs and online info I believe yes, the job must exist before you schedule it.  To verify this, just give it a try on a development database?  That's what development databases are for.

Now depending on how you call create_job, you might not need create_schedule.  If you set interval and start_date, it does both.

from: http://www.oracle-base.com/articles/10g/Scheduler10g.php
They can either be made up of predefined parts (programs and schedules)
0
 
lulubell-bAuthor Commented:
Thank you
0
 
slightwv (䄆 Netminder) Commented:
Glad to help.
0

Featured Post

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

  • 4
  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now