Re: How to log attempts to connect as a locked user account

  • From: Pete Finnigan <pete@xxxxxxxxxxxxxxxx>
  • To: Timur Akhmadeev <Akhmadeev@xxxxxxxxxxxxxx>
  • Date: Tue, 04 Aug 2009 15:03:12 +0100

Thanks Timur,

I was aware of the package but its part of Audit vault although shipped
with the 11g database and had forgotten its installed in 11g.

cheers

Pete

Timur Akhmadeev wrote:
> Hi,
> 
>  
> 
> Documented way for >= 10.2.0.3: New Feature DBMS_AUDIT_MGMT To Manage And 
> Purge Audit Information 
> <https://metalink2.oracle.com/metalink/plsql/f?p=130:14:9086829504850226415::::p14_database_id,p14_docid,p14_show_header,p14_show_help,p14_black_frame,p14_font:NOT,731908.1,1,1,1,helvetica>
>  
> 
>  
> 
> Thanks,
> 
> Timur Akhmadeev
> 
>  
> 
> -----Original Message-----
> From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On 
> Behalf Of Martin Klier
> Sent: Tuesday, August 04, 2009 13:23
> To: pete@xxxxxxxxxxxxxxxx
> Cc: 'oracle-l@xxxxxxxxxxxxx'
> Subject: Re: How to log attempts to connect as a locked user account
> 
>  
> 
> Thanks Pete, for your reply.
> 
>  
> 
> Pete Finnigan schrieb:
> 
>> Just to add there is a session view already built into the database
> 
>> SYS.DBA_AUDIT_SESSION that limits AUD$ to just session audit logs.
> 
>  
> 
> How can I configure the retention time of the audit log results? Is
> 
> there a link/paper somewhere, or could you explain this in a few words,
> 
> please?
> 
>  
> 
> Thanks
> 
> Martin
> 

-- 

Pete Finnigan
Director
PeteFinnigan.com Limited

Specialists in database security.

If you need help to audit or secure an Oracle database, please ask for
details of our courses and consulting services

Phone: +44 (0)1904 791188
Fax  : +44 (0)1904 791188
Mob  : +44 (0)7742 114223
email: pete@xxxxxxxxxxxxxxxx
site : http://www.petefinnigan.com

Registered Office: 9 Beech Grove, Acomb, York, YO26 5LD, United Kingdom
Company No       : 4664901
VAT No.          : 940 6681 14

Please note that this email communication is intended only for the
addressee and may contain confidential or privileged information. The
contents of this email may be circulated internally within your
organisation only and may not be communicated to third parties without
the prior written permission of PeteFinnigan.com Limited.  This email is
not intended nor should it be taken to create any legal relations,
contractual or otherwise.

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


Other related posts: