Re: user$.AUDIT$

From: Roger Xu <wellmetus_at_gmail.com>
Date: Wed, 23 Dec 2009 08:42:22 -0600
Message-ID: <eb64345d0912230642l206f102lec771ae45c10a412_at_mail.gmail.com>

my question is - what is the meaning of 5 dashes in the audit$ field? Thanks.

On Wed, Dec 23, 2009 at 7:21 AM, Goulet, Richard <Richard.Goulet_at_parexel.com
> wrote:

> Just because audit_train = none does not mean that the structures are not
> in place.
>
>
> *Dick Goulet***
> Senior Oracle DBA/NA Team Lead
> PAREXEL International
>
>
> ------------------------------
> *From:* oracle-l-bounce_at_freelists.org [mailto:
> oracle-l-bounce_at_freelists.org] *On Behalf Of *Roger Xu
> *Sent:* Tuesday, December 22, 2009 4:31 PM
> *To:* oracle-l_at_freelists.org
> *Subject:* user$.AUDIT$
>
> Hi Lister,
>
> Do you know what user$.AUDIT$ is for? I know it's for audit but our
> audit_trail is set to NONE.
> (Also, what is _NEXT_USER?)
>
> Thanks,
>
> Roger
>
> P.S.
>
> SQL> select * from v$version;
>
>
> BANNER
> ----------------------------------------------------------------
> Oracle9i Enterprise Edition Release 9.2.0.8.0 - 64bit Production
> PL/SQL Release 9.2.0.8.0 - Production
> CORE 9.2.0.8.0 Production
> TNS for HPUX: Version 9.2.0.8.0 - Production
> NLSRTL Version 9.2.0.8.0 - Production
>
> SQL> select name, AUDIT$ from user$
> 2 where name = '_NEXT_USER'
> 3 or name = 'W10574'
> 4 or name = 'ROGER';
>
>
> NAME AUDIT$
> ------------------------------ --------------------------------------
> ROGER
> W10574
> _NEXT_USER ------
>
> SQL> select name, AUDIT$ from user$
> 2 where name = '_NEXT_USER'
> 3 or name = 'W10574'
> 4 or name = 'ROGER'
> 5 or name = 'W9627';
>
>
> NAME AUDIT$
> ------------------------------ --------------------------------------
> W9627 ------
> ROGER
> W10574
> _NEXT_USER ------
>
> SQL>
>

--
http://www.freelists.org/webpage/oracle-l

Received on Wed Dec 23 2009 - 08:42:22 CST