.show restricted view access policy
Display 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. Deleting a policy is similar to disabling a policy.
Syntax
Display the policy for a table:
.show table TableName policy restricted-view-access
Display the policy for all tables:
.show table * policy restricted-view-access
Arguments
TableName - Specify the name of the table.
Returns
Returns a JSON representation of the policy.
Example
Display the policy for a table:
.show table Table1 policy restricted-view-access
Display the policies for all tables:
.show table * policy restricted-view-access