Control Reference

Dynamic Views for Row and Column Filtering

MEDIUMAccess ControlLow Complexity1-2 hours per view

AC-004

Description

Use dynamic views to implement row-level and column-level security using SQL logic, providing a lightweight alternative to ABAC policies for teams that need fine-grained filtering without the complexity of governed tags

Prerequisites

▸Unity Catalog enabled
▸Source tables registered in Unity Catalog
▸Understanding of which rows/columns to filter per group

Impact Analysis

SecurityImproves security posture

75%

ComplianceMeets compliance requirements

70%

ComplexityImplementation complexity

25%

CostResource cost impact

Required Permissions

Catalog Owner or Schema Owner

// Related

Related Controls

AC-001

CRITICAL

Implement Role-Based Access Control (RBAC)

Access Control

AC-002

HIGH

Implement Attribute-Based Access Control (ABAC)

Access Control

Back to Controls Browse Problems