Re: Trace who remove dba_jobs

if that is being done as part of another job, there is long standing bug that prevents all SQL run as (part of) a job is marked with address '0' or '00' in v$ and hence you can't detect through v$.

Perhaps you can audit dbms_job execs or create wrapper around dbms_job that logs calls to a table or to a file using utl_file. Make this new package in sys schema and call it dbms_my_job. Then create or replace public synonym dbms_job to point to dbms_my_job and you are good to go.

However this will not work if someone is using FQNC.

Raj

On 9/20/06, David Sharples <davidsharples_at_gmail.com> wrote:
> you cant
>
>
> On 20/09/06, Sinardy Xing <oracle.rdbms_at_gmail.com> wrote:
> >
> >
> > Hi guys,
> >
> > I have "CSI" task need to discuss with you.
> >
> > Some one remove dba_jobs, it is Oracle 8i how can I know who remove the
> job and what time,
>

-- 
----------------------------------------------
Got RAC?
--
http://www.freelists.org/webpage/oracle-l