RE: Turn Audit to Monitor Logins
Date: Fri, 5 Dec 2008 12:51:42 -0500
I suggest you see Ch 8 Database Auditing: Security Considerations in the Oracle(r) Database Security Guide 10g Release 2 (10.2) Part Number B14266-04 which covers basic reasons to audit. You can find the syntax in the SQL manual.
See view dba_audit_sessions in the Oracle version# Reference manual.
- Mark D Powell --
Phone (313) 592-5148
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Nagaraj S
Sent: Friday, December 05, 2008 12:28 PM To: oracle-l_at_freelists.org Subject: Turn Audit to Monitor Logins Hi Gurus, I have an requirement from applicaition team to "Turn audit onfor a an user in an Database, in order to monitor who logins (both failed and successful logins) to this account
and when the login is made and from where, etc, as far as Oracle can capture these information.
This audit is intended to find out who logins to the user repeatedly and unsuccessfully that caused the account to be locked in more than one occasions." Please help me on this
Regards, Nagaraj.Received on Fri Dec 05 2008 - 11:51:42 CST