Skip to content

Latest commit

 

History

History
50 lines (32 loc) · 1.57 KB

show-table-restricted-view-access-policy-command.md

File metadata and controls

50 lines (32 loc) · 1.57 KB
Raw
title description ms.reviewer ms.topic ms.date
.show table policy restricted_view_access command
Learn how to use the `.show table policy restricted_view_access` command to display the details of the table's restricted view access policy.
yonil
reference
05/24/2023

.show table policy restricted_view_access command

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.

Permissions

You must have at least Database User, Database Viewer, or Database Monitor permissions to run these commands. For more information, see role-based access control.

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

[!INCLUDE syntax-conventions-note]

Parameters

Name Type Required Description
TableName string ✔️ The name of the table for which to show the policy details.

Returns

Returns a JSON representation of the policy.

Examples

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