Can this be accomplished with Oracles Fine Grained Auditing? We need to audit when a table is accessed (either select, update or delete) and I know Oracles Fine Grained Auditing can handle that. The issue we are having is that all of our users use the same oracle account to log in and we need to audit WHO, using the users username on the application, did the action on this table.  What I was thinking is that we can just pass the users id in as part of the select statement ( select 'bob', col1, col2...) and that could possibly be accessed with Oracles Fine Grained Auditing.  

Does anyone have any experience in doing something like this or if it is even possible.  If not, any ideas on how we can accomplish this?

Thanks!

Forgot to mention that this is in Oracle 10G
Get the client to call dbms_session.set_identifier('PHILTEST');. This will then be set in the CLIENT_ID audit field. Obviously you'l need to call it first from the client whenever a new connection is pulled from the pool.

For example:

PHIL@PHILL11G2 &gt; conn / as sysdba
Connected.
Loading glogin.sql

Session altered.

SYS@PHILL11G2 AS SYSDBA&gt; audit all by phil by access;

Audit succeeded.

SYS@PHILL11G2 AS SYSDBA&gt; AUDIT SELECT TABLE, UPDATE TABLE, INSERT TABLE, DELETE TABLE BY ACCESS;

Audit succeeded.

SYS@PHILL11G2 AS SYSDBA&gt; truncate table aud$;

Table truncated.

SYS@PHILL11G2 AS SYSDBA&gt; TRUNCATE TABLE fga_log$;

Table truncated.

SYS@PHILL11G2 AS SYSDBA&gt; conn phil/phil

PHIL@PHILL11G2 &gt; exec dbms_session.set_identifier('PHILTEST');

PL/SQL procedure successfully completed.

PHIL@PHILL11G2 &gt; select count(*) from fgatest;

  COUNT(*)
----------
     1

PHIL@PHILL11G2 &gt; conn / as sysdba

SYS@PHILL11G2 AS SYSDBA&gt; select CLIENT_ID from dba_audit_trail;

CLIENT_ID
----------------------------------------------------------------
PHILTEST
PHILTEST

2 rows selected.

SYS@PHILL11G2 AS SYSDBA&gt;