I have an RDS Postgres database that uses only the public schema.
I expect that
webservice Users to gain access to all newly created views. When creating a view with the
master User, I see all the grants as expected.
Here are the DEFAULT PRIVILEGES that I have set up.
ALTER DEFAULT PRIVILEGES IN SCHEMA public GRANT SELECT, UPDATE, INSERT, DELETE ON TABLES TO webservice;
In my opinion, when the Rormigrationsuser creates a view in the public schema, it belongs to the Rorm migration, and none of the STANDARD PRIVILEGES exist. I have to change the owner to get the rights.
What can I do to fix these permission issues?