> ## Documentation Index
> Fetch the complete documentation index at: https://private-7c7dfe99-mintlify-fbfa8bee.mintlify.site/llms.txt
> Use this file to discover all available pages before exploring further.

> System table containing information about all masking policies in the system.

# system.masking_policies

export const CloudOnlyBadge = () => {
  return <div className="cloudBadge">
            <div className="cloudIcon">
            <svg width="16" height="16" viewBox="0 0 16 16" fill="none" xmlns="http://www.w3.org/2000/svg">
                <path fillRule="evenodd" clipRule="evenodd" d="M5.33395 12.6667H12.3739C13.6593 12.6667 14.7073 11.6187 14.7073 10.3334C14.7073 9.04804 13.6593 8.00004 12.3739 8.00004H12.0839V7.33337C12.0839 5.12671 10.2906 3.33337 8.08395 3.33337C6.09928 3.33337 4.45395 4.78537 4.14195 6.68204C2.55728 6.76271 1.29395 8.06204 1.29395 9.66671C1.29395 11.3234 2.63728 12.6667 4.29395 12.6667H5.33395Z" stroke="currentColor" strokeWidth="1.5" strokeLinecap="round" strokeLinejoin="round" />
            </svg>
        </div>
            {'ClickHouse Cloud only'}
        </div>;
};

<h2 id="description">
  Description
</h2>

Contains information about all masking policies defined in the system.

<h2 id="columns">
  Columns
</h2>

* `name` ([String](/reference/data-types/string)) — Name of a masking policy. The full name format is `short_name ON database.table`.
* `short_name` ([String](/reference/data-types/string)) — Short name of a masking policy. For example, if the full name is `mask_email ON mydb.mytable`, the short name is `mask_email`.
* `database` ([String](/reference/data-types/string)) — Database name.
* `table` ([String](/reference/data-types/string)) — Table name.
* `id` ([UUID](/reference/data-types/uuid)) — Masking policy ID.
* `storage` ([String](/reference/data-types/string)) — Name of the directory where the masking policy is stored.
* `update_assignments` ([Nullable(String)](/reference/data-types/nullable)) — UPDATE assignments that define how data should be masked. For example: `email = '***masked***', phone = '***-***-****'`.
* `where_condition` ([Nullable(String)](/reference/data-types/nullable)) — Optional WHERE condition that specifies when the masking should be applied.
* `priority` ([Int64](/reference/data-types/int-uint)) — Priority for applying multiple masking policies. Higher priority policies are applied first. Default is 0.
* `apply_to_all` ([UInt8](/reference/data-types/int-uint)) — Shows whether the masking policy applies to all roles and/or users. 1 if true, 0 otherwise.
* `apply_to_list` ([Array(String)](/reference/data-types/array)) — List of the roles and/or users to which the masking policy is applied.
* `apply_to_except` ([Array(String)](/reference/data-types/array)) — The masking policy is applied to all roles and/or users except the listed ones. Only populated when `apply_to_all` is 1.