Sample Header Ad - 728x90

Retaining access to table that will be dropped and recreated

0 votes
1 answer
203 views
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.
Asked by kinkajou (479 rep)
Apr 22, 2015, 04:05 AM
Last activity: Jun 16, 2025, 09:02 AM