Feedback Edit

.show restricted view access policy

  • Article
  • 2 minutes to read

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