permission denied to create and drop user

From: Joao Miguel Ferreira <joao(dot)miguel(dot)c(dot)ferreira(at)gmail(dot)com>
To: pgsql-general <pgsql-general(at)lists(dot)postgresql(dot)org>
Subject: permission denied to create and drop user
Date: 2021-02-02 21:58:15
Message-ID: CALyyT7Rd1KB=KhO=HKcpyvXVC9Qy9uKRzfAbcv3Z4E7cuBTJHg@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hello all,

I have just installed postgresql on Debian stable (from debian apt
archives). It seems that the postgres user does not have permissions to
DROP/CREATE USER. I was expecting the postgres user to be a superuser but
something seems weird. my postgres user does not have the usual superuser
attributes.

Please see my results bellow:

root(at)deb10tp:/# id
uid=0(root) gid=0(root) groups=0(root)
root(at)deb10tp:/# pwd
/
root(at)deb10tp:/# su postgres
postgres(at)deb10tp:/$ psql
psql (11.9 (Debian 11.9-0+deb10u1))
Type "help" for help.

postgres=> DROP USER foo;
ERROR: permission denied to drop role
postgres=> DROP USER postgres;
ERROR: permission denied to drop role
postgres=> CREATE USER foo;
ERROR: permission denied to create role
postgres=> \du
List of roles
Role name | Attributes | Member of
-----------+------------+-----------
pgcon | | {}
postgres | | {}

How do I get a superuser/postgres that is capable to CREATE / DROP another
user? or a user that might allowed to do anything?

Thank you
Joao

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Adrian Klaver 2021-02-02 22:27:56 Re: permission denied to create and drop user
Previous Message Hellmuth Vargas 2021-02-02 20:45:21 Re: count(*) vs count(id)