0

I am using a postgresql database in production and we need to apply fine grained auditing for certain tables. The requirement is, sensitive data related tables should only be accessed by application user. If any other user accesses those tables, a log entry should be created.

Can PGAUDIT extension support such kind of functionality ?

Laurenz Albe
  • 167,868
  • 16
  • 137
  • 184
Nishantha Pradeep
  • 67
  • 1
  • 1
  • 8
  • Your audit trigger need to know who issued the command that fired it and react accordingly (log or not). Maybe [this](https://stackoverflow.com/questions/13172524/passing-user-id-to-postgresql-triggers) post sheds light on your problem. – Stefanov.sm Jun 17 '21 at 06:30

0 Answers0