I have a RDS postgres database that only uses the public schema.
I expect the
webservice user to get access to all newly created views. When I create a view using the
master user, I see all the grants as expected.
Here are the DEFAULT PRIVILEGES I have setup.
ALTER DEFAULT PRIVILEGES IN SCHEMA public GRANT SELECT, UPDATE, INSERT, DELETE ON TABLES TO webservice;
When the rormigration user creates a view in the public schema, I see it is owned by rormigration and none of the DEFAULT PRIVILEGES are present. I have to switch the owner to master and grant rights.
What can I do to fix this permission issues?