Subject | Database triggers |
---|---|
Author | Aage Johansen |
Post date | 2009-09-22T19:21:49Z |
Is it possible to use the CONNECT event of the database triggers to
catch failed attempts to log in to a database? Maybe only successful
logins triggers the trigger?
If a failed attempt is caught, will the trigger operate with SYSDBA privileges?
I would like to log failed login attemps in some way, like inserting
a row in some table (hmmm, is creating an entry in the server's event
log possible?) The info I would like to save is some identification
of the client pc, the user that is logged in at that pc and the
username that is used with the login attempt (in addition to a timestamp).
--
Aage J.
catch failed attempts to log in to a database? Maybe only successful
logins triggers the trigger?
If a failed attempt is caught, will the trigger operate with SYSDBA privileges?
I would like to log failed login attemps in some way, like inserting
a row in some table (hmmm, is creating an entry in the server's event
log possible?) The info I would like to save is some identification
of the client pc, the user that is logged in at that pc and the
username that is used with the login attempt (in addition to a timestamp).
--
Aage J.