Checking Log Files for Failed Logon Attempts 

Use

The database system logs errors and important messages in several log files. For information about the name, path and function of log files, see Concepts of the Database System, Log Files.

By monitoring the log files, you can identify unusual activity in a timely way.

Procedure

Regularly check the following log files for failed logon attempts:

·        Log file of the Database Manager

·        Log file of the Loader

Example

Messages from the Database Manager for the database instance DEMODB are logged in the log file c:\Documents and Settings\All Users\Application Data\sdb\data\wrk\DEMODB\dbm.prt. In the event of a failed logon attempt, the Database Manager writes the following message in this log file:

command user_logon
ERR_USRFAIL: user authorization failed