Egor , thanks for you response. I want to find out the hostname from where the user connected? What is the viewname I should use? I did enable "audit create session by USERA" Thanks in advance Sami On 11/8/05, Egor Starostin <egorst@xxxxxxxxx> wrote: (http://download-west.oracle.com/docs/cd/B10501_01/server.920/a96536/ch2203.htm#1307451) -- //www.freelists.org/webpage/oracle-l