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@xxxxxxxxx> wrote:
you cant


On 20/09/06, Sinardy Xing <oracle.rdbms@xxxxxxxxx> 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


Other related posts: