Conference Schedule - PGConf.DE 2020

Automated User and Access Management in a DBaaS Environment

Date: 2020-05-15
Time: 12:50 - 13:35
Room: Room 2

In a Database-as-a-Service environment, the life cycle of large numbers of databases, users and access rules need to be managed in a fully automated and self-service way. At the same time, user and database configuration should follow enterprise standards and application requirements. In this presentation we show how we automate the setup of users in SwissRe DBaaS, including entries in pg_hba.conf, so that access to databases can be granted and revoked by authorized users in self-service mode without manual activities. Furthermore, we elaborate how to support standardized yet flexible database configurations that can be enhanced with application-specific customizations, such as non-default extensions.


Andreas Geppert
Karsten Lenz