How to Avoid Grants to Public for a Table Created in Target Database

Question

How can I avoid grants to public for a table created in a target database by HVR?

Environment

HVR 5

Answer

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.

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