Re: oracle system audit for local host activity

dan - can you give me an example, now, of how to implement system auditing on oracle 9.2, capturing *only* events caused as a result of interactions with the database from a local terminal?

the question that this started with is how to discriminate what goes into the audit table by terminal. you can audit by user, easily. you can audit by statement, easily. my question is how to audit by terminal. I do not want to put events in the audit table that are created as a result of networked access to the database.

I am more interested in oracle 9.2, but will gladly receive advice that is general in nature.

thanks much...

/rpf
DA Morgan wrote:
> Richard wrote:
> > DA Morgan wrote:
> >
> >> And you presume that the Oracle edition and version are unimportant?
> >> Why? ;-)
> >>
> >
> > 9.2 ...though I am interested in subsequent versions as well and
> > presume that the strategy would be the same?
> >
> > dan - would you use a different strategy for different versions?
> >
> > thank you very much for my question.
> >
> > /rpf
>
> Absolutely different on different versions.
> Auditing may involve a lot of different technologies including, but
> not limited to, audit, fine grained audit (dbms_fga), enabling the
> ORA_ROWSCN pseudocolumn, event triggers, SQLNET audit, etc.
>
> Different versions and different needs enable different solutions.
> --
> Daniel Morgan
> Puget Sound Oracle Users Group
Received on Sat Sep 16 2006 - 12:31:52 CDT