Retrieving Username Using Oracle Triggers

Question

I am new to using triggers. What function can I use to determine who tripped my trigger?

For example:
Someone updates a row, and I want to know who updated the row.

I am using Oracle 10g.

Answer 1

SELECT sys_context('USERENV', 'SESSION_USER') FROM dual;

or

SELECT sys_context('USERENV', 'SESSION_USERID') FROM dual;