Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Auditing ALL activities on a table

Auditing ALL activities on a table

From: nirav <shivam71_at_gmail.com>
Date: 29 May 2006 06:26:46 -0700
Message-ID: <1148909206.875400.302880@i40g2000cwc.googlegroups.com>


Hi

I need to have a detailed audit on ALL activities of a table..ie I need to know all the SELECT, INSERT,UPDATE, DELETE against the table(DDLs against the table need not be audited..)

how can this be done? it should be such that the exact sql statement fired against the table should be captured..can this be done via fga or some other means?

appreciate ur help.. Received on Mon May 29 2006 - 08:26:46 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US