Re: Trigger Help

From: clifford buetikofer <clifford_buetikofer_at_merck.com>
Date: Mon, 07 Dec 1998 13:31:23 -0500
Message-ID: <366C1EFB.2CE62C8B@merck.com>

My 2 Cents...

A while back someone gave me this SQL snippet to get the OSUser:

Oracle 7.3.2

---

select osuser from user_session where audsid = USERENV('SESSIONID');

Oracle 8.0.4

---

select osuser from aps_session where audsid = USERENV('SESSIONID');

Cliff

       The contents of this message express only the sender's opinion.
       This message does not necessarily reflect the policy or views of
       my employer, Merck & Co., Inc.  All responsibility for the statements
       made in this Usenet posting resides solely and completely with the
       sender.

Received on Mon Dec 07 1998 - 12:31:23 CST