Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> Help: Auditing database access
Dear group,
I am using Oracle 10.2.0.3 on linux. I am testing auditing who access my database.
I set audit_trail=db and issue "audit create session".
what I found in sys.aud$, most of them is from "sysman" and "dbsnmp", that is from dbconsole. When i do
"delete from sys.aud$ where cast ( (from_tz(ntimestamp#,'00:00') at
local) as date) < sysdate-60", that is very slow, because majority of
the records are from sysman/dbsnmp
Is there any way we can do
"audit create session except sysman and dbsnmp"?
Thanks for your help Received on Wed Jun 13 2007 - 14:49:34 CDT
![]() |
![]() |