We have 2 postgresql users. One user (
dbworkeruser) for creating tables dynamically (from C# worker) and other user (
injestworkeruser) for inserting data into these tables (from another C# worker as well).
The main issue that we have is that, every time we do drop/create new tables dynamically (on runtime) we get exception that the user
injestworkeruser doesn't have enough permission to select or insert data from/into these newly created tables. This is the created user:
CREATE USER injestworkeruser WITH
Is there anyway to grant the user permissions to apply CRUD operations to any newely created table?
This one didn't work for me as this applies to the existing tables:
GRANT ALL PRIVILEGES ON ALL TABLES IN SCHEMA public TO injestworkeruser;