Hi,

We have a webbased application with ASP front end. I am trying to write a trigger on a table to gather information like OSUser and DBuser when updates and deletes are done on that table with the query

SELECT USERNAME,OSUSER INTO V_DBUSER,V_OSUSER FROM V$SESSION

But, when the update/delete is done through ASP, it is givning the osuser as SYSTEM. Is there any function or any other method which gives me the correct OSUSER id?

Thanks in advance
MS Reddy