I have an application which uses Postgres.
The application periodically drop tables and the recreates
them. I have to manage the users privileges
on these tables. I can NOT change anything in the application code. When the application drops and recreates
tables all GRANTS are dropped and I have to recreate
GRANTS from the scratch. Any approach not to repeat such job every time?
The application periodically drop tables and the recreates
them. I have to manage the users privileges
on these tables. I can NOT change anything in the application code. When the application drops and recreates
tables all GRANTS are dropped and I have to recreate
GRANTS from the scratch. Any approach not to repeat such job every time?