Managing permissions with Postgres event triggers

How event triggers can be used to provide a flexible mechanism for permissions management at scale.