Presented by:

A16e64a0534a4c526847866690beec93

HariKrishna

from AWS

A thorough database professional - Oracle, PostgreSQL. Deeply involved in Customer initiatives viz. Database Migration and Modernisation, Digital Transformation, Data Centre Exit Programmes and chalk out clear migration plan and be integral part and lead the execution team.

65d0f0a3d8e53b68fbd08a4a605cf42b

Rajesh Madiwale

from Amazon Web Services

Lead Consultant at Amazon Web Services.

No video of the event yet, sorry!

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 worldloads on Postgres Operators in Kubernetes
  2. Start Time:
    2023 February 24 14:45

    Room:
    Grand Victoria 2