RE: Turn Audit to Monitor Logins

From: Powell, Mark D <>
Date: Fri, 5 Dec 2008 12:51:42 -0500
Message-ID: <>

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

[] On Behalf Of Nagaraj S

	Sent: Friday, December 05, 2008 12:28 PM
	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          


Received on Fri Dec 05 2008 - 11:51:42 CST

Original text of this message