how to determine the osuser of a session

Hi NewsGroup,

<Oracle 9.2i>

for debugging we wrote down a logging that stores some information to file and to database.
It would be easier to handle, if such a record also contains the osuser or the terminal he sits on, so that you differentiate between the users (in our case we implemented an own user management, so that "SELECT userid FROM DUAL" is useless).
I could do this from inside the program, but so I had to rebuilt and redeliver the program. Therefore I decided to use a trigger that fills every new record of that table with this information. Is there a possibility to do so?

Thanks

Andreas

-- 
wenn email, dann AndreasMosmann <bei> web <punkt> de