Postgres permission issues for new views 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?
DEFAULT PRIVILEGES only apply to objects that the user creates. I didn't have DEFAULT PRIVILEGES setup for rormigration so users didn't get rights to objects created by rormigration.

I reviewed DEFAULT PRIVILEGES and then ran the missing grants while logged in as rormigration.

SELECT *
FROM pg_default_acl acl
JOIN pg_namespace ns ON ns.oid = acl.defaclnamespace;