You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
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.
The text was updated successfully, but these errors were encountered:
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;
GRANT
ing 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 hasSUPERUSER
privileges and makes some already implemented and needed workarounds (e.g. for the IBM cloud) unnecessary.The text was updated successfully, but these errors were encountered: