Capturing User Name

[gleyd]

I have a trigger that fires when certain fields are changed to post the old and new values to a transaction log. This works fine. I want to capture the userid of the user that caused the trigger to fire. How do I trap the user?

I am using a MS-Access97 front-end connecting to Oracle 8.0.5 back-end using Oracle 8 ODBC Driver.

 

[matrixcd]

Try turning on Oracle Audit the will capture all events

 

[RandyD]

use the USER pseudocolumn:

e.g.

select USER from DUAL;

hth
Randy

 

[gleyd]

Thank You,
select USER from DUAL worked.