thinQmaster Virtual testing partner Adaptive practice exams that find your weak spots and drill them. Every answer explained. From $69
Enroll

thinQmaster

Find your exam

Five questions free, before you decide.

Step 1 · choose a vendor

In one of our camps? Your practice exams come with the tuition — they are on your study page already.

Data & Analytics · Intermediate

Column-Level Security

Restricting access to specific columns, for example through column GRANTs, masking policies or object-level security.

Definition

Implementations include GRANT SELECT on specific columns in SQL Server, Fabric Warehouse and Synapse, Snowflake masking policies, Unity Catalog column masks and Power BI OLS.

Example

GRANT SELECT ON Employees (EmpID, Name, Dept) TO Analysts;

Exam tip

Hide whole columns = column-level security or OLS; partially obscure values = masking.

Related terms