Re: DBMS_JOB question

From: Paul Brewer <paul_at_paul.brewers.org.uk>
Date: Thu, 28 Nov 2002 22:03:33 -0000
Message-ID: <3de7ba40_2@mk-nntp-1.news.uk.worldonline.com>

"Jan Gelbrich" <j_gelbrich_at_westfalen-blatt.de> wrote in message news:as1sf0$mnibn$1_at_ID-152732.news.dfncis.de...
> > Also it is definitely *A VERY BAD IDEA* to create your *OWN*
> > procedures in the *SYS* schema.
> >
> >
> > Sybrand Bakker, Senior Oracle DBA
> >
>
> Yup, You are right, it is just a preliminary test solution.
> Sys should always be kept clean of everything.
> It is just some privs that are still missing to be granted ...
>
> Yours, Jan
>
>

Then grant them, instead of running as SYS. These kinds of shortcuts do not save time; they just add difficulty later when you find that they do not work in production.

In addition to which, if you do something to a job you need to commit, or the rest of the system can't see it.

Regards,
Paul Received on Thu Nov 28 2002 - 16:03:33 CST