How to audit a particular user actions in the database ?

Hi All,

We have a support database accounts in our production database and
we would like to enable auditing for the support id's only without setting up AUDIT_TRAIL=DB or OS parameter .

How to audit a particular user actions in the database ?

Tks in Advance,
Raju

Hi,
Which database version are you using.If the database version is 8i then you can write database triggers to audit a particular user action eventhough you have disabled auditing on the database through AUDIT_TRAIL.

Regards,
Rohit Nirkhe,Oracle DBA,OCP 8i
[email protected]