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

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).