Skip to content

Add operator user to created roles by default #110

@tstenner

Description

@tstenner

Creating a database fails unless the operator user is either SUPERUSER (not the case in some public clouds) or is in the new owner role.

The issue can be reproduced locally with a non-superuser role:

CREATE ROLE pgoperator WITH
	PASSWORD 'pgoperator'
	LOGIN
	CREATEDB
	CREATEROLE;

GRANTing the created role to the operator user is already done as a workaround for some clouds, but it should be done by default. It doesn't hurt when the user has SUPERUSER privileges and makes some already implemented and needed workarounds (e.g. for the IBM cloud) unnecessary.

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions