Re: check expired user accounts

From: Douglas Hawthorne <douglashawthorne_at_yahoo.com.au>
Date: Tue, 23 Mar 2004 14:15:21 GMT
Message-ID: <ZDX7c.121460$Wa.86604@news-server.bigpond.net.au>

"Martin Burkert" <burki5000_at_gmx.at> wrote in message news:qmd060h8ra3a9e8t4oh87bdqctjldt4buf_at_4ax.com...
> Hi!
>
> I would like to check, when a user account of my oracle 9i database
> expires.
> The problemset is, that I use some "offline tools", which are using
> encrypted textfiles containing the user account data. But Im not able
> to
> trigger, when a user account expires or is locked (e.g. because the
> user is
> typing the wrong password for three times and so on).
>
> However, it is not possible to set a trigger as sys on user$ or on the
> view
> v_user. Is there a workaround?
>
> Greetings
> Martin
>
>

Martin,

Tom Kyte has a recommendation to use "audit connect whenever NOT successful;" at
http://asktom.oracle.com/pls/ask/f?p=4950:8:8391907379648794591::NO::F4950_P8_DISPLAYID,F4950_P8_CRITERIA:1830073957439, to trap unsuccessful logon attempts. This is probably the simplest way to implement your requirements.

Daniel Morgan has published a sample trigger to detect failed logon attempts at http://www.psoug.org/reference/system_trigger.html which you may want to develop into something more suited to your needs.

Douglas Hawthorne Received on Tue Mar 23 2004 - 08:15:21 CST