At 11:16 AM 8/4/2004 -0400, you wrote: >It isn't being done with a trigger. > >I may use the following sql. > >audit insert,update, delete on GL_BALANCES; > >Question is how to add a specific user to the above statement. > >This database is still 8.1.7.4, so I think Fine Grain Audit is not an = >option. There is a BY clause on the AUDIT statement which lets you specify a user_list. Unfortunately, you can not use the BY clause if you are using the ON clause. ---------------------------------------------------------------- Please see the official ORACLE-L FAQ: http://www.orafaq.com ---------------------------------------------------------------- To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx put 'unsubscribe' in the subject line. -- Archives are at //www.freelists.org/archives/oracle-l/ FAQ is at //www.freelists.org/help/fom-serve/cache/1.html -----------------------------------------------------------------