Edit on GitHub
How to Avoid Grants to Public for a Table Created in Target Databaselink
Problem Summarylink
How to avoid grants to public for a table created in a target database by HVR?
Descriptionlink
When HVR creates a table in the target database, by default the table is accessible by public. However, you can control this in HVR if you don’t want to give the grant to public.
Answerlink
You can modify the default behavior by using the DbObjectGeneration /RefreshTableGrant action on the target.
The following are the parameter options:
NONE (default, if the table is created in the default schema): Does not execute the grant statement.
SELECT_TO_PUBLIC: executes grant select on <tablename> to public
ALL_TO_PUBLIC (default): executes grant all on <tablename> to public