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

> 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