Encryption of Data Specific to a Tenant in PostgreSQL database | General Idea - Mailing list pgsql-general

From Jagmohan Kaintura
Subject Encryption of Data Specific to a Tenant in PostgreSQL database | General Idea
Date
Msg-id CA+cYFttZSge7QztGcwgKYF-8ZOWZ-07h1A1qZZkjTUA5=OodxA@mail.gmail.com
Whole thread Raw
Responses Re: Encryption of Data Specific to a Tenant in PostgreSQL database | General Idea
List 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. 

pgsql-general by date:

Previous
From: Guy Burgess
Date:
Subject: PostgreSQL occasionally unable to rename WAL files (NTFS)
Next
From: Tim Cross
Date:
Subject: Re: Encryption of Data Specific to a Tenant in PostgreSQL database | General Idea