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@xxxxxxxxxxx > 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@xxxxxxxxxxxxx [mailto: > oracle-l-bounce@xxxxxxxxxxxxx] *On Behalf Of *Roger Xu > *Sent:* Tuesday, December 22, 2009 4:31 PM > *To:* oracle-l@xxxxxxxxxxxxx > *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> >