drop_security_predicate
Drop a FILTER predicate from a row-level security policy on a specified table. Useful for reverting or modifying security filters in Fabric Data Warehouse.
Instructions
Drop the FILTER predicate from an existing row-level security policy.
Executes ALTER SECURITY POLICY ... DROP FILTER PREDICATE ON. The
T-SQL DROP PREDICATE ON syntax takes no operation qualifier.
There is no predicate-type parameter (#966): Fabric Data Warehouse
supports FILTER predicates only.
Args:
workspace: Workspace name or GUID.
item: Warehouse or SQL endpoint name or GUID.
policy_name: Qualified policy name ("schema.name" or "name").
table_schema: Schema name of the target table.
table_name: Name of the target table.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| item | Yes | ||
| workspace | Yes | ||
| table_name | Yes | ||
| policy_name | Yes | ||
| table_schema | Yes |
Output Schema
| Name | Required | Description | Default |
|---|---|---|---|
No arguments | |||