I’m trying to create a read-only user on an AWS RDS PostgreSQL database. I am logging in using psql, with the default user that was created in the RDS dashboard when I created the database. Yesterday I was able to create a role called readonly, but I realized I did not add some parameters I wanted to add such as
NOSUPERUSER INHERIT NOCREATEDB NOCREATEROLE NOREPLICATION so I deleted the role. Then I went to create the role again and the operation timed out with a weird error, so I disconnected.
Well today when I tried to log in with the same user and create a role with command
CREATE ROLE readonly;, I get:
ERROR: permission denied to create role. I ran the command l and see this (I am myuser for example):
Any tips on how to resolve this? Do you think I triggered some kind of security protection so I am no longer allowed to create a role?
Go to Source