2 Answers
- Newest
- Most votes
- Most comments
0
Hello,
Can you try running the following first as a role that has rds_superuser:
ALTER SCHEMA public OWNER to master;
And if that resolves your issue?
Thanks!
John H
Edited by: awsatjohnh on Apr 12, 2019 6:15 PM
answered 6 years ago
0
I could resolve it.
I had to run as master:
ALTER SCHEMA public OWNER TO master;
GRANT ALL ON SCHEMA public TO master;
Now I can access the objects in public again. However, it is strange why it happened that no role could access the public object anymore. Did the migration procedure change the owner and revoke the grants?
Edited by: vimlech on Apr 15, 2019 1:57 AM
answered 6 years ago
Relevant content
- asked 2 years ago
- asked 9 months ago
- AWS OFFICIALUpdated 6 months ago
- AWS OFFICIALUpdated 2 years ago
- AWS OFFICIALUpdated 8 months ago
- AWS OFFICIALUpdated a year ago