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 -> Audit command help

Audit command help

From: Teresa Redmond <NJZLIRWUWYGI_at_spammotel.com>
Date: Mon, 08 Mar 2004 21:51:09 GMT
Message-ID: <a1ebc36a3d1f262f0be466b6b9b47bbb@news.teranews.com>


Hello again, (oracle 8.1.5 on win2kPro)

In testing the auditing I set up last week, I've worked up a few more questions. Is it possible to audit objects by who does something to them? I've been reading the Audit Statement in http://download-east.oracle.com/docs/cd/F49540_01/DOC/index.htm and this doc show two audit statements: for object, and for sql statements. For what I want to do, seeing who deletes or updates what and what statement is used (among a few other things), should I use the audit sql statement syntax?

As in: "audit delete table, update table, by user1, user2, user3;".

Also, I finished putting in the audit statements for the tables last week, but have seen thousands and thousands of results put in sys.aud$ and sys.dba_audit_object on the "select" statement, which I did not include in my audit statement. I entered "audit delete, update on schema.table;" for every table in the schema. I'm unsure why I would see results on a "select", but I am trying to learn this so am not surprised that I don't know why. :-)

I just ran "noaudit all;" and am trying to clear out the almost 700,000 rows that appeared since last week. Delete from sys.aud$ is *very* slow...

Thanks again for your help!

-- 
Teresa Redmond
Programmer/Analyst III
Anteon Corporation
tredmond at anteon dot com
Received on Mon Mar 08 2004 - 15:51:09 CST

Original text of this message

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