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

Report message to a moderator

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: 68770
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
No way if you didn't previously activate AUDIT.

Regards
Michel

Report message to a moderator

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

Report message to a moderator

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: 68770
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
show parameter audit
dba_priv_audit_opts
dba_stmt_audit_opts

Regards
Michel

Report message to a moderator

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

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri Sep 19 18:50:58 CDT 2025
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.