How to audit only one userid?

From: Badri Narasimhan <badri_at_concentric.net>
Date: 1997/04/29
Message-ID: <5k517a$aag_at_chronicle.concentric.net>#1/1


Hi:

        I only want to audit specific userids. How would I do it? I thought of a trigger on sys.aud$ with the following options:

  1. I cant skip inserts - although I would like to for all other userids.
  2. I cant use raise_application_error on all other userids as well since this will cause an error in the application.
  3. Also, I cannot do rollback in the trigger on all other users since this will alter the actions of the application

Haaaaalp,

thanks a lot,

-Badri Received on Tue Apr 29 1997 - 00:00:00 CEST

Original text of this message