A tool or utility to track/log which db user executed a sql script or db centric shell script?

I'm looking for a tool or utility to track/log which db user executed a sql script. Something like userid, script name (*.sql), date, time, # of executions, etc. Something that could continuously run inside the database or as a cron or service at the file system level.

Also a tool or utility to track/log which db user executed a database centric shell script.

Any ideas appreciated.