I'm trying to create a new user in AWS Aurora Postgres DB.
Create user worked fine and I can login to the DB using that account. granting permissions to it isn't.
GRANT ALL on ALL tables in schema public to username
ERROR: permission denied for relation some_table
some_table owner is a member of the same group the the new user.
Then, trying another grant options:
ALTER DEFAULT PRIVILEGES FOR USER username IN SCHEMA public GRANT ALL ON tables TO group this_group;
ERROR: must be member of role "username"
Any idea how to solve it out?