Encryption with customer provided key in a multi tenant Postgres JSONB DB

Поиск
Список
Период
Сортировка
От Saurav Sarkar
Тема Encryption with customer provided key in a multi tenant Postgres JSONB DB
Дата
Msg-id CAP+kwAUHrZSSMjTY5YZhZ1QFCNZPSZka2Og0eMCt063AF4PhQg@mail.gmail.com
обсуждение исходный текст
Ответы Re: Encryption with customer provided key in a multi tenant Postgres JSONB DB  ("David G. Johnston" <david.g.johnston@gmail.com>)
Re: Encryption with customer provided key in a multi tenant Postgres JSONB DB  (Michael Lewis <mlewis@entrata.com>)
Список pgsql-general

Hi All,

We use Postgres's JSONB structure for NoSQL usage.

We have a multi tenant application where for each tenant we create separate tables . So for e.g. if i have 100 tenants then i have 100 tables.

Now we want to have encryption for the data in the tables with the tenant provided key. Is it possible to encrypt tables in the same database with different keys. ?

I learnt that PostgreSQL itself does not support encryption at database level or other finer granular levels . May i please know if in future can this be supported ? or is it not possible technically at all ?

I have posted a similar question on SF

https://stackoverflow.com/questions/64719415/encryption-with-customer-provided-key-in-a-multi-tenant-postgres-jsonb-db


Best Regards,

Saurav

В списке pgsql-general по дате отправления:

Предыдущее
От: RAJAMOHAN
Дата:
Сообщение: Re: Need to place pgpool logs on separate directory
Следующее
От: "David G. Johnston"
Дата:
Сообщение: Re: Encryption with customer provided key in a multi tenant Postgres JSONB DB