Why am I getting permission denied on an ownership change?
14
votes
4
answers
18053
views
My current user is
pronto
mediapop_staging=> select current_user;
current_user
--------------
pronto
(1 row)
This user a standard super user created on AWS RDS.
mediapop_staging=> \du pronto
List of roles
Role name | Attributes | Member of
-----------+-------------------------------+-----------------
pronto | Create role, Create DB +| {rds_superuser}
| Password valid until infinity |
But I'm getting this:
mediapop_staging=> REASSIGN OWNED BY pronto TO mediapop_staging;
ERROR: permission denied to reassign objects
Why? How can I resolve it?
Asked by Kit Sunde
(363 rep)
Jul 16, 2018, 07:16 AM
Last activity: Oct 16, 2023, 09:36 PM
Last activity: Oct 16, 2023, 09:36 PM