It's a long time since I last checked, but doesn't
the audit_trail=db include an option to audit
connect on failure ? Would that be sufficient
for the original poster ?
--
Regards
Jonathan Lewis
http://www.jlcomp.demon.co.uk
Coming soon one-day tutorials:
Cost Based Optimisation
Trouble-shooting and Tuning
Indexing Strategies
(see http://www.jlcomp.demon.co.uk/tutorial.html )
____UK_______March 19th
____USA_(FL)_May 2nd
Next Seminar dates:
(see http://www.jlcomp.demon.co.uk/seminar.html )
____USA_(CA, TX)_August
The Co-operative Oracle Users' FAQ
http://www.jlcomp.demon.co.uk/faq/ind_faq.html
DA Morgan wrote in message <3E4D1DF9.B8F5DDF2_at_exesolutions.com>...
>Tanel Poder wrote:
>
>> Hello!
>>
>> You could write your own password verify function for Oracle and
set it to
>> all (any) users with PASSWORD_VERIFY_FUNCTION profile option. You
could keep
>> a log in some table - using autonomous transactions.
>>
>> I haven't tried it, but it should work if there's no specific
restrictions
>> during logon.
>>
>> Tanel.
>>
>> "DA Morgan" <damorgan_at_exesolutions.com> wrote in message
>> news:3E4CB6D4.D01A1E83_at_exesolutions.com...
>> > Andris Jancevskis wrote:
>> >
>> > > Hi!
>> > >
>> > > How can I check usuccessfull login attempt?
>> > > I can check time when user lon in with database triger, but it
is
>> > > _after_ event. Should I modify trigger SYS_LOGON ?
>> > >
Received on Fri Feb 14 2003 - 11:40:41 CST
