Re: Identify user from database link

From: Turkbear <john.g_at_dot.spamfree.com>
Date: Fri, 28 Jan 2005 14:50:28 -0600
Message-ID: <8b9lv0dc1n7cb2k1077g9vs5n235nqhifr@4ax.com>

"Terry Dykstra" <tddykstra_at_forestoil.ca> wrote:

>When I select osuser from v$session I see entries like ABC\XYZ$ (Where ABC
>is domain, XYZ is the database server).
>From the username I know who they are, but that's not good enough. Is there
>any way of knowing from which remote database these users are connecting?
>Databases are 817 and 92 Standard Edition.

See if Terminal, Program or some of the other fields in v$session will tell you. Received on Fri Jan 28 2005 - 14:50:28 CST