How can I find session which had started(submited) job ?
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 5 of 5

Thread: How can I find session which had started(submited) job ?

  1. #1
    Join Date
    Jun 2006
    Posts
    8

    How can I find session which had started(submited) job ?

    I have this problem: - All users connect to database as user OD. And when one session has submited JOB, his Oracleuser=OD. But all sessions which have connected to database have ORacleUser=OD and I can not find - Who generated(submited) this JOB ??????

    P.S. Sorry my bad English !

  2. #2
    Join Date
    May 2000
    Location
    ATLANTA, GA, USA
    Posts
    3,135
    Ask the user to send a email to you after he submits a job.

    Tamil

  3. #3
    Join Date
    Jan 2001
    Posts
    3,131
    You could ask.
    I remember when this place was cool.

  4. #4
    Join Date
    Jul 2000
    Posts
    521
    Are your users using same username for OS log-in ? If not, you could look at OSUSER in V$SESSION. If they use same OS user also, its high time for you to consider security !!
    svk

  5. #5
    Join Date
    Mar 2004
    Location
    DC,USA
    Posts
    650
    Its time for you to implement role based user login access for the accountability. This will get you who is doing what.

    Other wise follow Tamil.
    "What is past is PROLOGUE"

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width