Program Name without using V$SESSION
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 5 of 5

Thread: Program Name without using V$SESSION

  1. #1
    Join Date
    Nov 2004
    Posts
    8

    Program Name without using V$SESSION

    Hi,
    I try to get the user program name which is connected to Oracle 9i. I can't use V$SESSION. I didn't find anything in sys_context() function pour the program name. How can I get this information ?
    Thanks

  2. #2
    Join Date
    Apr 2003
    Location
    Gourock, Scotland
    Posts
    102
    Which Operating System? If unix, does ps -ef show anything? If Windows, does task manager show the session?
    If I have to choose between two evils, I always like to choose the one I haven't tried yet.

  3. #3
    Join Date
    Nov 2004
    Posts
    8
    Oracle 9 - HP UX
    But I try to get this information from a trigger and I can't use v$session because of privilege

  4. #4
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,333
    get the privelege then, if you need it you need it

  5. #5
    Join Date
    Nov 2000
    Location
    Pittsburgh, PA
    Posts
    3,999
    You could always create a view, or a function owned by another schema that only returns information for the calling session.
    this space intentionally left blank

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