RE: user$.AUDIT$

From: Mark W. Farnham <mwf_at_rsiz.com>
Date: Wed, 23 Dec 2009 09:35:35 -0500
Message-ID: <B1B925C992914B00B34E676A39D941EF_at_rsiz.com>

select x.user#,x.name

   from (select user#,name from sys.user$ order by user# desc) x

where rownum < 5;  

should illustrate what _NEXT_USER is.  

---

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:35:35 CST