RE: Turn Audit to Monitor Logins
- From: "Powell, Mark D" <mark.powell@xxxxxxx>
- To: <oracle-l@xxxxxxxxxxxxx>
- 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
________________________________
From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Nagaraj S
Sent: Friday, December 05, 2008 12:28 PM
To: oracle-l@xxxxxxxxxxxxx
Subject: Turn Audit to Monitor Logins
Hi Gurus,
I have an requirement from applicaition team to "Turn audit on
for 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.
Other related posts:
