How to Avoid Grants to Public for a Table Created in Target Database
Problem Summary
How to avoid grants to public for a table created in a target database by HVR?
Description
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.
Answer
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