Sample Header Ad - 728x90

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