Re: how can i know who drop the job

From: Mark D Powell <Mark.Powell_at_eds.com>
Date: 19 Jul 2006 06:29:34 -0700
Message-ID: <1153315774.895207.110570@b28g2000cwb.googlegroups.com>

sybrandb wrote:
> flying wrote:
> > If a job is removed, how can a DBA know who did it and from which
> > client station? I have looked into the online log, but found no
> > evidence. the version of oracle is 9.2.0.2
>
> Only the job owner can remove the job, and nothing is tracked.
> If you audit the connections of the job owner, you can may be find out
> something.
> You could of course write your own wrapper for dbms_job including audit
> code and revoke access from dbms_job.
>
> --
> Sybrand Bakker
> Senior Oracle DBA

flying, If this is an ongoing problem I would think that you might want to use the builtin audit command on sys.job$.

Also check the permissions on the undocumented package dbms_ijob as I do believe that any job can be purged via this package. This is the package that actually does the work for dbms_jobs and should normally not be called directly so only user SYS and the import_full_database and export_full_database system privileges should be able to access it.

HTH -- Mark D Powell -- Received on Wed Jul 19 2006 - 08:29:34 CDT