> 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 -- //www.freelists.org/webpage/oracle-l