.alter restricted view access policy

Enable or disable the optional table restricted view access policy. When this policy is enabled for a table, data in the table can only be queried by principals who have an UnrestrictedViewer role in the database.

Syntax

Enable or disable the policy for one table:

.alter table TableName policy restricted-view-access true|false

Enable or disable the policy for several tables:

.alter tables (TableName,TableName2,TableName3,...) policy restricted-view-access true|false

Arguments

TableName - Specify the name of the table.

Examples

Enable a policy for a table

.alter table MyTable policy restricted-view-access true

Disable the policy of several tables

.alter tables (Table1, Table2, Table4) policy restricted-view-access false