Re: Finding database link connection origin

From: Joe Kazimierczyk <kazimiej_at_bms.com>
Date: 14 Jan 2002 04:58:37 -0800
Message-ID: <e2242da1.0201140458.6b2c854c@posting.google.com>

You can find out what IP address the connection came from. But if there are multiple databases on that box, I don't think you can tell which one. You can check 'after the fact' if you have session auditing enabled: look for audit records where dba_audit_trail.sessionid = v$session.audsid. The comment field will give you the connection source informatino.

In the login trigger, you can get the IP address via sys_contect & userenv.

n.a.ekern_at_usit.uio.no wrote:
>
> Hi all.
>
> We are using Oracle 8.1.7 databases.
>
> I am wondering, if a database DB1 is accessed over a database link, is
> there any way to find out the following:
>
> The database from which the database link connection is coming from.
>
> If there is, I am planning on having a logon trigger logging this, and
> maybe deny the logon.
>
Received on Mon Jan 14 2002 - 06:58:37 CST