Home » RDBMS Server » Security » Find User Usage Log (oracle 9i)
Find User Usage Log [message #352087] Mon, 06 October 2008 01:12 Go to next message
mm_kanish05
Messages: 493
Registered: January 2007
Location: Chennai
Senior Member

How to find out the logged in period of a user and the tables accessed by the user during a given period of time of a day.

kanish
Re: Find User Usage Log [message #352101 is a reply to message #352087] Mon, 06 October 2008 02:48 Go to previous messageGo to next message
Michel Cadot
Messages: 68624
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
No way if you didn't previously activate AUDIT.

Regards
Michel
Re: Find User Usage Log [message #352105 is a reply to message #352101] Mon, 06 October 2008 03:36 Go to previous messageGo to next message
mm_kanish05
Messages: 493
Registered: January 2007
Location: Chennai
Senior Member

Thanks,

How do i check whether Audit enable or not?


kanish
Re: Find User Usage Log [message #352110 is a reply to message #352105] Mon, 06 October 2008 03:52 Go to previous message
Michel Cadot
Messages: 68624
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
show parameter audit
dba_priv_audit_opts
dba_stmt_audit_opts

Regards
Michel
Previous Topic: HOW TO RESTRICT THE USER FROM DISABLING TRIGEER STATUS
Next Topic: Can I move AUD$ table to another tablespace
Goto Forum:
  


Current Time: Thu Mar 28 08:42:21 CDT 2024