Home » RDBMS Server » Security » Problem with aud$ table
Problem with aud$ table [message #158808] Tue, 14 February 2006 08:56
toshidas2000
Messages: 120
Registered: November 2005
Senior Member
All
I have auditing turned on 10g database. When I query the sys.aud$ table.

select sessionid, to_char(timestamp#,'DD-MON-YY:HH24:MI:SS') login,userid, to_char(logoff$time,'DD-MON-YY:HH24:MI:SS') logoff
from sys.aud$

I only see todays login. why so and login filed is also blank for all connections. Please help.

Thanks
Toshi

Report message to a moderator

Previous Topic: External users and ORA-01017
Next Topic: Restricted User Role
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Sat Oct 17 12:37:04 CDT 2026
.:: Forum Home :: Wiki Home :: Contact :: Privacy ::.