RE: user$.AUDIT$
- From: "Mark W. Farnham" <mwf@xxxxxxxx>
- To: <wellmetus@xxxxxxxxx>, <oracle-l@xxxxxxxxxxxxx>
- Date: Wed, 23 Dec 2009 09:35:35 -0500
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@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>
Other related posts:
