I have a set of apps that produce data. Each app has its own credentials to access the DB, and they all inherit from a common role (
I'd like to set default privileges to grant access to objects created by a
producer, but it does not work because objects are owned by each particular app's login, not by
So: is there a way to have all tables created by these apps to be owned by
producer not by their particular login ? Or, is there a way to write these default privileges differently ?
EDIT: and I'd like to avoid changing all apps to make them do a SET ROLE...