OraFAQ Forum: Security » Find User Usage Log

Home » RDBMS Server » Security » Find User Usage Log (oracle 9i)

Mon, 06 October 2008 01:12

mm_kanish05
Messages: 488
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

Mon, 06 October 2008 02:48

Michel Cadot
Messages: 67743
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

No way if you didn't previously activate AUDIT.

Regards
Michel

Mon, 06 October 2008 03:36

mm_kanish05
Messages: 488
Registered: January 2007
Location: Chennai

Senior Member

Thanks,

How do i check whether Audit enable or not?

kanish

Mon, 06 October 2008 03:52

Michel Cadot
Messages: 67743
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 Feb 25 02:18:24 CST 2021