Re: How to log attempts to connect as a locked user account
From: Rich Jesse <rjoralist_at_society.servebeer.com>
Date: Fri, 31 Jul 2009 09:46:31 -0500 (CDT)
Message-ID: <5fa6a3f800551e4d0157b8b8e4e711d8.squirrel_at_society.servebeer.com>
Hey Martin,
Date: Fri, 31 Jul 2009 09:46:31 -0500 (CDT)
Message-ID: <5fa6a3f800551e4d0157b8b8e4e711d8.squirrel_at_society.servebeer.com>
Hey Martin,
AUDIT SESSION will probably do what you're looking for. Check out the OracleŽ Database Security Guide from http://tahiti.oracle.com for each of your versions.
Note that there's at least a few ways to setup auditing and the versions can act a little differently IIRC.
HTH! GL! Rich
> 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).
-- http://www.freelists.org/webpage/oracle-lReceived on Fri Jul 31 2009 - 09:46:31 CDT