Re: Auditing actions done by the DBA.

The thing to watch out for is that for 'connect internal', 'connect / as sysdba', oracle only audits the fact that someone connected. Any sql that you're trying to audit is not audited at all.

Brian Peasland wrote:
>
> Niall,
>
> I believe that this is audited as well. You can easily verify this. On a
> Unix platform, any "connect internal" operations generate a "*.aud" file
> in $ORACLE_HOME/rdbms/audit. Connect with "connect / as sysdba" and see
> if an audit file is generated.
>
> HTH,
> Brian
>
> Niall Litchfield wrote:
> >
> > "Sybrand Bakker" <postbus_at_sybrandb.demon.nl> wrote in message
> > news:th5k6ngf4rk69e_at_beta-news.demon.nl...
> > > BTW, connect internal is audited and can't be disabled.
> > >
> > what about connect / as sysdba?
> >
> > --
> > Niall Litchfield
> > Oracle DBA
> > Audit Commission UK
>
> --
> ========================================
> Brian Peasland
> Raytheons Systems at
> USGS EROS Data Center
> These opinions are my own and do not
> necessarily reflect the opinions of my
> company!
> ========================================
Received on Thu May 31 2001 - 05:49:18 CDT