TransWikia.com

Schema level encryption in Postgres

Database Administrators Asked by Turgs on December 8, 2021

A multi-tenancy approach for many webapps is to use a separate PostgreSQL schema for each tenant.

In addition to permissions and access controls, is it possible to encrypt a tenant’s whole schema using something like PGP?

In my scenario, the webapp connects to PostgreSQL using a single webapp user account. In other words, tenants won’t connect to the database with their own database user credentials.

Add your own answers!

Ask a Question

Get help from others!

© 2024 TransWikia.com. All rights reserved. Sites we Love: PCI Database, UKBizDB, Menu Kuliner, Sharing RPP