Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
Switch services using the Version drop-down list. Learn more about navigation.
Applies to: ✅ Microsoft Fabric ✅ Azure Data Explorer
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
Learn more about syntax conventions.
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