Re: Turn Audit to Monitor Logins

Many thanks Powell. I am reading the document. Regards,
Naga

On Fri, Dec 5, 2008 at 11:21 PM, Powell, Mark D <mark.powell_at_eds.com> wrote:

> I suggest you see Ch 8 Database Auditing: Security Considerations in the
> Oracle(R) Database Security Guide 10*g* 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_at_freelists.org [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 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.
>
>

--
http://www.freelists.org/webpage/oracle-l