Speaker
Description
No, not under the table - for things within a table, like columns and rows. Fine grained access controls let administrators manage access to specific pieces of data. Granting a user permission to read a piece of data doesn't have to mean access to all the details either, values can be masked, rounded, classified into buckets, ... As regulation makes data privacy controls more important and the tools for exploring and exploiting data become more diverse, enforcing these controls in the database is an appealing option for ensuring that the enforcement is consistent.
Postgres column-level permissions, row-level security, security labels, and the pg_anonymize extension offer advanced mechanisms for controlling access to data. Join me for an overview of how you can use them to control exactly who sees what.
