Re: trigger to unsuccessfull login

From: wavey <dave_at_nospam35ad.com>
Date: Sun, 16 Feb 2003 01:36:02 -0000
Message-ID: <fspm2b.m8o.ln@192.168.1.245>

"Andris Jancevskis" <ajandris_at_parks.lv> wrote in message news:3E4CB017.9030801_at_parks.lv...
> Hi!
>
> How can I check usuccessfull login attempt?

audit_trail = db in the init.ora

sqlplus /nolog
connect / as sysdba
audit session whenever not successful

sys.aud$ will contain records where logons have failed. Be sure to watch the size of this table as its (normally) in the system tablespace.

select * from DBA_AUDIT_SESSION is also useful

hope this helps,

Dave.
email (-nospam) Received on Sat Feb 15 2003 - 19:36:02 CST