How to log attempts to connect as a locked user account
- From: Martin Klier <usn@xxxxxxxxx>
- To: "'oracle-l@xxxxxxxxxxxxx'" <oracle-l@xxxxxxxxxxxxx>
- Date: Fri, 31 Jul 2009 15:52:58 +0200
Dear list, I want to design poor man's auditing for one single case: My user accounts are locked, and I want to log the connection attempts. But since there is no BEFORE LOGON ON DATABASE trigger (for rather obvious reasons). (Background info: Decommissioning of a test database: I want to find ancient jobs or autistic developers that don't complain, before dropping the storage there.) Is there any best practice for this? I'm using 9i, 10g and 11g. Thanks for any response Martin Klier -- Usn's IT Blog for Linux, Oracle, Asterisk http://www.usn-it.de -- http://www.freelists.org/webpage/oracle-l
- Follow-Ups:
- RE: How to log attempts to connect as a locked user account
- From: Timur Akhmadeev
- RE: How to log attempts to connect as a locked user account
Other related posts:
- » How to log attempts to connect as a locked user account - Martin Klier
- » RE: How to log attempts to connect as a locked user account - Timur Akhmadeev
- » Re: How to log attempts to connect as a locked user account - Rich Jesse
- » Re: How to log attempts to connect as a locked user account - Bradd Piontek
- » Re: How to log attempts to connect as a locked user account - Yong Huang
- » Re: How to log attempts to connect as a locked user account - chet justice
- » Re: How to log attempts to connect as a locked user account - Martin Klier
- » Re: How to log attempts to connect as a locked user account - Pete Finnigan
- » Re: How to log attempts to connect as a locked user account - Martin Klier
- » Re: How to log attempts to connect as a locked user account - Pete Finnigan
- » Re: How to log attempts to connect as a locked user account - chet justice
- » RE: How to log attempts to connect as a locked user account - Timur Akhmadeev
- » Re: How to log attempts to connect as a locked user account - Pete Finnigan
- » Re: How to log attempts to connect as a locked user account - Pete Finnigan