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