I have a small GIS table that is is dropped and recreated from a third-party tool called MAPINFO.
Each time I drop and recreate that table I grant access to roles created. Is it possible to retain access even after drop and create?
I cannot run SQL through Mapinfo. It does not provide truncate table – it just drops the table and creates a new one.
Answer left in comments by spaghettidba
Do you have control over the schema where the table gets created?
If so, you could grant privileges on the schema.
Another option is a DDL trigger to grant permissions on the table upon creation.