Presented by:

65d0f0a3d8e53b68fbd08a4a605cf42b

Rajesh Madiwale

from Amazon Web Services

Lead Consultant at Amazon Web Services.

Checkout the slides

Several large enterprise customers need to get database users with their actions audited and notified in near realtime for suspicious database activity for corrective action is of prime importance.

A custom audit solution was developed to track the suspicious activities like granting/revoking un-authorised access role/privileges by particular user(s). This solution further extends the capability to notify the required stakeholders for corrective action in reasonable time window. Since, this being a generic solution using PostgreSQL native extension of pgaudit and open source log parsing tool gives the edge of implementing this solution across other customers with similar use-cases.

Presenter : HariKrishna & Rajesh Madiwale

Date:
2023 February 24 - 14:45
Duration:
45 min
Room:
Robusta + Arabica
Conference:
PGConf India, 2023
Language:
Track:
Database Administration
Difficulty:
Medium

Happening at the same time:

  1. Running Production workloads on Postgres Operators in Kubernetes
  2. Start Time:
    2023 February 24 14:45

    Room:
    Grand Victoria 2