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

2002-05-24 Thread Denham Eva
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 in procedure? Wow, this worked exactly

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

2002-05-23 Thread Jared . Still
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, May 22, 2002 8:49 PM To: Multiple

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

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

AW: OSUSER in V$SESSION capture in procedure?

2002-05-22 Thread v . schoen
.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 capture

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

2002-05-22 Thread Chaim . Katz
.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 capture

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 whom.

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

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

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

2002-05-22 Thread Denham Eva
-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 a procedure