RE: user$.AUDIT$
From: Goulet, Richard <Richard.Goulet_at_parexel.com>
Date: Wed, 23 Dec 2009 08:21:59 -0500
Message-ID: <6B0D50B70F12BD41B5A67F14F5AA887F030E83B2_at_us-bos-mx022.na.pxl.int>
Just because audit_train = none does not mean that the structures are not in place.
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: Wed, 23 Dec 2009 08:21:59 -0500
Message-ID: <6B0D50B70F12BD41B5A67F14F5AA887F030E83B2_at_us-bos-mx022.na.pxl.int>
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-lReceived on Wed Dec 23 2009 - 07:21:59 CST