> ## Documentation Index
> Fetch the complete documentation index at: https://docs.bytebase.com/llms.txt
> Use this file to discover all available pages before exploring further.

# Column Masking

<Info>
  Masking precedence: [Masking Exemption](/security/data-masking/access-unmasked-data) > [Global Masking Rule](/security/data-masking/global-masking-rule) > [Column Masking](/security/data-masking/column-masking).
</Info>

In the project level, besides `Workspace Admin` and `DBA`, `Project Owner` can set table columns semantic type to mask the data.

<Note>
  This page covers relational databases. For document databases (**MongoDB** and **Elasticsearch**), field-level masking is configured through the collection/index Catalog instead — see [Document Database Masking](/security/data-masking/document-database-masking).
</Note>

Go to the **table detail** page, and click the **pen icon** and apply the semantic type.

<img src="https://mintcdn.com/dbx/hVml3kA8vNK6vcVL/content/docs/security/data-masking/bb-column-masking.webp?fit=max&auto=format&n=hVml3kA8vNK6vcVL&q=85&s=801a27802dca72c0bd85902404df594b" alt="bb-column-masking" width="2174" height="1134" data-path="content/docs/security/data-masking/bb-column-masking.webp" />

Combined with [Semantic Types](/security/data-masking/semantic-types), here is the result you will get in **SQL Editor**.

<img src="https://mintcdn.com/dbx/yhR4_AKNF_MEUOA1/content/docs/security/data-masking/bb-sql-editor-partial-masking.webp?fit=max&auto=format&n=yhR4_AKNF_MEUOA1&q=85&s=0959a3c9b080697098c97c550fb7d1ff" alt="bb-sql-editor-partial-masking" width="1364" height="684" data-path="content/docs/security/data-masking/bb-sql-editor-partial-masking.webp" />

However, if the global masking rule is also applied, the result will be as follows. Because the global masking rule takes precedence over the column masking.

<img src="https://mintcdn.com/dbx/yhR4_AKNF_MEUOA1/content/docs/security/data-masking/bb-sql-editor-full-masking.webp?fit=max&auto=format&n=yhR4_AKNF_MEUOA1&q=85&s=9d8f6f23838a3154eff8c36720665267" alt="bb-sql-editor-full-masking" width="1398" height="616" data-path="content/docs/security/data-masking/bb-sql-editor-full-masking.webp" />
