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

> System table which contains properties of configured setting profiles.

# system.settings_profiles

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

Contains properties of configured setting profiles.

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

* `name` ([String](/reference/data-types)) — Setting profile name.
* `id` ([UUID](/reference/data-types)) — Setting profile ID.
* `storage` ([String](/reference/data-types)) — Path to the storage of setting profiles. Configured in the `access_control_path` parameter.
* `num_elements` ([UInt64](/reference/data-types)) — Number of elements for this profile in the `system.settings_profile_elements` table.
* `apply_to_all` ([UInt8](/reference/data-types)) — Shows that the settings profile set for all roles and/or users.
* `apply_to_list` ([Array(String)](/reference/data-types)) — List of the roles and/or users to which the setting profile is applied.
* `apply_to_except` ([Array(String)](/reference/data-types)) — The setting profile is applied to all roles and/or users excepting of the listed ones.

<h2 id="see-also">
  See Also
</h2>

* [SHOW PROFILES](/reference/statements/show#show-profiles)