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
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) |