DBAsupport.com Forums - Powered by vBulletin
Results 1 to 5 of 5

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

  1. 07-18-2006, 02:54 PM #1
    aimak
    aimak is offline Junior Member
    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 !
    Reply With Quote Reply With Quote
  2. 07-18-2006, 03:50 PM #2
    tamilselvan
    tamilselvan is offline Senior Advisor
    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
    Reply With Quote Reply With Quote
  3. 07-18-2006, 04:50 PM #3
    Mr.Hanky's Avatar
    Mr.Hanky
    Mr.Hanky is offline X-Mas poo
    Join Date
    Jan 2001
    Posts
    3,134
    You could ask.
    I remember when this place was cool.
    Reply With Quote Reply With Quote
  4. 07-19-2006, 05:52 AM #4
    svk
    svk is offline Advisor
    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
    Reply With Quote Reply With Quote
  5. 07-19-2006, 10:55 AM #5
    dbasan's Avatar
    dbasan
    dbasan is offline Advisor
    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"
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

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

Forum Rules

Click Here to Expand Forum to Full Width