user$.AUDIT$
From: Roger Xu <wellmetus_at_gmail.com>
Date: Tue, 22 Dec 2009 15:31:02 -0600
Message-ID: <eb64345d0912221331x6a12107fsbc2ef26da79fb7e7_at_mail.gmail.com>
Hi Lister,
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
W10574
_NEXT_USER ------
SQL> select name, AUDIT$ from user$
ROGER
W10574
_NEXT_USER ------
SQL>
Date: Tue, 22 Dec 2009 15:31:02 -0600
Message-ID: <eb64345d0912221331x6a12107fsbc2ef26da79fb7e7_at_mail.gmail.com>
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-lReceived on Tue Dec 22 2009 - 15:31:02 CST