I want to execute a trigger each time a record is inserted/updated/deleted. I want to write some data to an audit table, including who made the change to the record. How can I retrieve the current logged on user?

Any advice appreciated,
Pieter

select USER from dual;

will retrieve the user if it is used inside of a stored procedure, package or even trigger.

select USER
into variable
from dual;

will insert USER into a variable, variable must be declared

default value may be USER or :=USER for the field.

Hope this helps.



Sal

Thanks for the input Sal!

Pieter