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 -> Re: Help: Auditing database access

Re: Help: Auditing database access

From: Mladen Gogala <mgogala.SPAM_ME.NOT_at_verizon.net>
Date: Tue, 26 Jun 2007 11:57:04 GMT
Message-ID: <pan.2007.06.26.11.57.04@verizon.net>


On Wed, 13 Jun 2007 12:49:34 -0700, emdproduction wrote:

> 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

How about a login trigger on the schemas that you really want to audit?

-- 
http://www.mladen-gogala.com
Received on Tue Jun 26 2007 - 06:57:04 CDT

Original text of this message

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