Encryption of Data Specific to a Tenant in PostgreSQL database | General Idea

From: Jagmohan Kaintura <jagmohan(at)tecorelabs(dot)com>
To: "pgsql-generallists(dot)postgresql(dot)org" <pgsql-general(at)lists(dot)postgresql(dot)org>
Subject: Encryption of Data Specific to a Tenant in PostgreSQL database | General Idea
Date: 2021-02-11 01:17:10
Message-ID: CA+cYFttZSge7QztGcwgKYF-8ZOWZ-07h1A1qZZkjTUA5=OodxA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

HI All,

For POstgreSQL database to store data for multiple tenants, the approach
decided was to have
Shared Database (Holding data for all tenants)
=> Data would be segregated on basis of some additional column
(tennatid,different tenants having different tenantId)
=> Data would be accessed through Views on the basis of tenantId
value.

This is the basic process of most of the customers who are trying to
implement multiple tenants in PostgreSQL, rather than choosing
separate databases for each tenant.

Now we need to encrypt the data related to a tenantId, so that now one
knows this data belongs to which tenant even from Operations group.
Is there a method in POstgreSQL for encrypting data with different keys
with respect to different values in a single column. Moreover pg_crypto
will impose a single key on the column.

Please share your thoughts in which direction i can start analysing this
area for encryption of data specific to a tenant.

Thanks in advance.
*Best Regards,*
Jagmohan
Senior Consultant, TecoreLabs.

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tim Cross 2021-02-11 01:45:39 Re: Encryption of Data Specific to a Tenant in PostgreSQL database | General Idea
Previous Message Guy Burgess 2021-02-11 00:21:12 PostgreSQL occasionally unable to rename WAL files (NTFS)