Re: DBMS_JOB - changing default grant

From: agis <stag_at_hq.acn.gr>
Date: Wed, 29 Sep 2004 11:15:06 +0300
Message-ID: <cjdqua$sd8$1@ulysses.noc.ntua.gr>

"Dusan Bolek" <pagesflames_at_usa.net> wrote in message news:1e8276d6.0409290006.2b715a67_at_posting.google.com...
> Hello,
>
> I want to revoke EXECUTE on DBMS_JOB from PUBLIC, because it seems to
> me like a good idea. I think that DBMS_JOB is too dangerous to be
> granted to anybody, Are there any side effects of this? I do now know
> if this grant is not needed for some internal Oracle purposes. I
> haven't find anything on this on Metalink.
>
> Thanks for info
>
> --
> Dusan Bolek
> http://www.db-support.com
>
> Email: spambin_at_seznam.cz
> Pls add "Not Guilty" to the subject, otherwise your email will face an
> unpleasant end as SPAM.

It is not a quite big think, because even everyone can execute dbms_job if does not have the ability to execute other packages or piece of code there is no prob. Received on Wed Sep 29 2004 - 03:15:06 CDT