Question

Does Local Data Processing change grants and privileges on the tables while doing refresh with options drop and recreate selected?

Environment

Local Data Processing

Answer

When a refresh is performed with options drop/recreate for the tables all the grants on the tables are gone. 

1. When option ‘create absent tables’ it will automatically enable the checkbox for ‘Alter or Recreate Tables’ 
2. If the radio button for ‘if mismatched’ is selected then the table will be dropped and recreated if the DDL structures are different. In this case, the grants on the table are gone on the target
3. If the radio button for ‘Always recreate’ is selected then the table will be always dropped and recreated irrespective of its DDL structure. In this case, the grants on the table are gone on target