Hi,
I'm facing a problem in finding out the user who has accessed/triggered the job which is scheduled in crontab and accessing the oracle tables.
I used the following code to find it out. But the user_name column is NULL. How do I check the last day's job run.
Please help me to find the user.
select log_id,log_date,owner,job_name,status,user_name,client_id from dba_scheduler_job_log
where log_id in (select log_id
from dba_scheduler_job_run_details
where trunc(log_date) = to_date('01/06/2014', 'mm/dd/yyyy')
)