Using PostgreSQL for Data Privacy and Security

Data scientists want access to data sets quickly, but organizations often need to protect private data, whether due to internal policy or government regulations.

In this talk we discuss how to leverage PostgreSQL for managing organization-wide data access while protecting privacy.

Topics include:

• Row Level Security
• Purpose-based data access
• Federating data
• Foreign data wrappers
• Masking
• Differential privacy
• k-anonymity
• Auditing with pgAudit