Re: dba_audit_session.userhost=1 - What does it mean?

From: Egor Starostin <egorst@xxxxxxxxx>
To: Sami Seerangan <dba.orcl@xxxxxxxxx>
Date: Wed, 9 Nov 2005 12:26:36 +0600

> I want to find out the hostname from where the user connected? What is
> the viewname I should use?
It seems that your only option for Oracle 9i is to use
dba_audit_session.terminal column (unfortunately, it's often empty).

Funny thing is that starting from Oracle 10g you can use userhost
column for the purposes you initially wanted -- in 10g userhost column
means "Client host machine name"
(http://download-west.oracle.com/docs/cd/B14117_01/server.101/b10755/statviews_2050.htm#sthref1639)


--
Egor
http://www.oracledba.ru
--
http://www.freelists.org/webpage/oracle-l

References:

dba_audit_session.userhost=1 - What does it mean?
From: Sami Seerangan

Re: dba_audit_session.userhost=1 - What does it mean?
From: Egor Starostin

Re: dba_audit_session.userhost=1 - What does it mean?
From: Sami Seerangan

Re: dba_audit_session.userhost=1 - What does it mean?

Other related posts: