What is best way to create a user that have access to all or some databases?

[kirek007]

Hey,
I'm wondering what would be the best way to give some users access to the all or some database that are managed by operator. Creating a dedicated user for each database would be an overkill for non-production environments so I'm looking for something simpler.

It would be great if I could create user with a list of databases he can access and as a result I would have only once account to provide to the developer.

Thanks in advance! :)

[pcallewaert]

At this moment this is not supported.

We have also this use case but we just templated the Postgres/PostgresUser in the helm chart so it does create a database/database user per dev environment. Using the dropOnDelete on the Postgres also helps to clean up the databases.