Home » RDBMS Server » Security » Problem with aud$ table
Problem with aud$ table [message #158808] Tue, 14 February 2006 08:56
Messages: 120
Registered: November 2005
Senior Member
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.

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

Current Time: Sat Jun 25 02:43:49 CDT 2022