RE: AW: OSUSER in V$SESSION capture in procedure?

2002-05-23 Thread Denham Eva
session only. Jared Denham Eva <[EMAIL PROTECTED]> Sent by: [EMAIL PROTECTED] 05/22/2002 11:23 PM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> cc: Subject: RE: AW: OSUSER in V$SESSION capture

RE: AW: OSUSER in V$SESSION capture in procedure?

2002-05-23 Thread Jared . Still
to ORACLE-L To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> cc: Subject: RE: AW: OSUSER in V$SESSION capture in procedure? Wow, this worked exactly as I hoped. Many Thanks. -Original Message- [mailto:[EMAIL PROTECTED]] Sent: Wednesday, M

RE: AW: OSUSER in V$SESSION capture in procedure?

2002-05-22 Thread Denham Eva
://www.inplan.de -Ursprüngliche Nachricht- Von: Denham Eva [mailto:[EMAIL PROTECTED]] Gesendet: Mittwoch, 22. Mai 2002 17:34 An: Multiple recipients of list ORACLE-L Betreff: OSUSER in V$SESSION capture in procedure? Hello Listers, I have what I hope is challenging problem. I am trying to create

RE: OSUSER in V$SESSION capture in procedure?

2002-05-22 Thread Kevin Lange
you can also get the sid directly (if you don't want to use any packages) from the steve adams script: select p.pid, s.sid, s.serial# from sys.v_$session s, sys.v_$process p where s.sid = (select sid from sys.v_$mystat where rownum = 1) and p.addr = s.paddr / from this you can lo

RE: OSUSER in V$SESSION capture in procedure?

2002-05-22 Thread Kevin Lange
One thing that is possible to get a unique system id you can allways do the following: When the user logs into your application, place a record in a table stating all the pertinent info like application, machine id, date/time, etc. Allowing with this info use the DBMS_SESSION package and get

Re: OSUSER in V$SESSION capture in procedure?

2002-05-22 Thread Stephane Faroult
Denham Eva wrote: > > Hello Listers, > > I have what I hope is challenging problem. > I am trying to create a procedure that execs from a trigger on a table. > Simple enough. > But I want to capture the OSUSER value from v$session so that the there is a > history of changes to the table and by w

Re: AW: OSUSER in V$SESSION capture in procedure?

2002-05-22 Thread Chaim . Katz
est of procedure.Includes insert etc END TEST HTH Volker Schoen E-Mail: mailto:[EMAIL PROTECTED] http://www.inplan.de -Ursprüngliche Nachricht- Von: Denham Eva [mailto:[EMAIL PROTECTED]] Gesendet: Mittwoch, 22. Mai 2002 17:34 An: Multiple recipients of list ORACLE-L Betreff: OSUSER in V

AW: OSUSER in V$SESSION capture in procedure?

2002-05-22 Thread v . schoen
procedure.Includes insert etc END TEST HTH Volker Schoen E-Mail: mailto:[EMAIL PROTECTED] http://www.inplan.de -Ursprüngliche Nachricht- Von: Denham Eva [mailto:[EMAIL PROTECTED]] Gesendet: Mittwoch, 22. Mai 2002 17:34 An: Multiple recipients of list ORACLE-L Betreff: OSUSER in V$SESSION

RE: OSUSER in V$SESSION capture in procedure?

2002-05-22 Thread Magaliff, Bill
I, too, have a situation whereby all users access the db via third party app with single credentials - haven't found a way around it, other then application-side logging -bill -Original Message- Sent: Wednesday, May 22, 2002 11:34 AM To: Multiple recipients of list ORACLE-L Hello Liste

OSUSER in V$SESSION capture in procedure?

2002-05-22 Thread Denham Eva
Hello Listers, I have what I hope is challenging problem. I am trying to create a procedure that execs from a trigger on a table. Simple enough. But I want to capture the OSUSER value from v$session so that the there is a history of changes to the table and by whom. Problem with using USER functi