Top
Enterprise Postgres 16 Security Operation Guide

4.10 Analyzing Logs

Create a mechanism that analyzes logs to detect unauthorized behavior in cases where information leakage, unauthorized access, or other such activity, is suspected. Analyses should include those shown below.

Periodic analysis of session information

Analyze session information of logs from the perspectives below to detect unauthorized logins:

  • Trend of sessions with a large number of failed login attempts

  • Trend of sessions with accounts that are logged in for long periods of time

  • Trend of sessions in which a large amount of resources are used

Periodic analysis of database access information

Analyze SQL statements from the perspectives below to detect unauthorized access to the database:

  • Trend of SQL being executed over a long period of time

  • Trend of SQL using a large amount of resources