Grants and Privileges after Refresh with Alter and Recreate Option Selected

Question

Do grants and privileges on the tables change when a refresh is performed with the alter and recreate option selected?

Environment

HVR 5

Answer

When a refresh is performed with the alter and recreate option selected for the tables, all the grants on the tables might be revoked.

When you select the Create Absent Tables option, the Alter or Recreate Tables option is automatically selected, and you can choose one of the following options:

• If mismatched: The table is dropped and recreated only if the DDL structures are different and the grants on the table are removed in the target.
• Always Recreate: The table is always dropped and recreated irrespective of its DDL structure and the grants on the table are revoked in the target.