---
title: "Discussion on \"Build a Postgres Audit Log Your Application Code Cannot Bypass\" | Hashnode"
description: "Discussion on \"Build a Postgres Audit Log Your Application Code Cannot Bypass\". Build a tamper-resistant audit log in Postgres using triggers and SECURITY DEFINER, proven with a live permissions test."
url: "https://hashnode.com/posts/build-a-postgres-audit-log-your-application-code-cannot-bypass/6aa6d1c4cc1a30739efd1b9e"
---

[Feed](https://hashnode.com/feed) /

Discussion

# [Build a Postgres Audit Log Your Application Code Cannot Bypass](https://uduakukpong.hashnode.dev/build-a-postgres-audit-log-your-application-code-cannot-bypass?utm_source=hashnode&utm_medium=feed)

Build a tamper-resistant audit log in Postgres using triggers and SECURITY DEFINER, proven with a live permissions test.

Sep 13 · 11 min read · uduakukpong.hashnode.dev  
Read the article

-   [#postgresql](https://hashnode.com/tag/postgresql)
-   [#postgres](https://hashnode.com/tag/postgres)
-   [#database](https://hashnode.com/tag/database)
-   [#tutorial](https://hashnode.com/tag/tutorial)
-   [#audit-logs](https://hashnode.com/tag/audit-logs)
-   [#security](https://hashnode.com/tag/security)

## Written by

[Uduak Ukpong](https://hashnode.com/@flhlxix)

@flhlxix · Lagos, Nigeria

  
[View profile](https://hashnode.com/@flhlxix)

Writing up on the engineering problems I actually hit in production.

I'm a full-stack Developer working across React, Next.js, NestJS, and PostgreSQL.

## Responses

Markdown supported · ⌘↵ to post

No responses yet.
