Re: Help: Auditing database access

On Jun 13, 3:49 pm, emdproduct..._at_hotmail.com 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

Have you tried looking at the oracle product documentation?

Let's see there's the concepts guide, the sql reference guide, the security guide ( chapter 8 database auditing ), ...

If you do a google search on the words oracle and audit .... hmmm wonder if anything relevant turns up there?

Have fun reading. Pete Finnigan is probably a site to get familiar with. Received on Wed Jun 13 2007 - 15:42:31 CDT