I have around 5 test postgres databases on a RDS instance. Till date all have been created and run using the Master_user (created at the instance creation).
I am now trying to create 5 new users and Grant ALL privilages for each of the databases respectively. I tried Pgadmin4 Grant wizard, but I get permission denied error for any grant option. Grant ALL doesnt work, and Grant Create, Insert etc also doesn't work. What could be the issue??
I just ended up backing up all the databases with --no-owner --no-acl, renaming the databases and creating new ones with new owners. restored each backup with each owner and achieved what I wanted.