Problem Summary: How to avoid grants to public for a table created in Target database by HVR
Description:
When a table is created by HVR in the target database by default this table is accessible by public but there is a way to control this in HVR if you don’t wish to give the grant to pubic.
Answer:
This behavior can be modified by using action DbObjectGeneration /RefreshTableGrant on the Target.
Below are the available options for this parameter
NONE (default, if the table is created in default schema): Do not execute grant statement.
SELECT_TO_PUBLIC: executes grant select on tablename to public
ALL_TO_PUBLIC (default): executes grant all on tablename to public