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
lulubell-bAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

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 Ultimate Tool Kit for Technolgy Solution Provi

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy for valuable how-to assets including sample agreements, checklists, flowcharts, and more!

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

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
lulubell-bAuthor Commented:
Thank you
0
slightwv (䄆 Netminder) Commented:
Glad to help.
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Oracle Database

From novice to tech pro — start learning today.