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

> System table containing filters for one particular table, as well as a list of roles and/or users which should use this row policy.

# system.row_policies

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

Contains filters for one particular table, as well as a list of roles and/or users which should use this row policy.

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

* `name` ([String](/reference/data-types)) — Name of a row policy.
* `short_name` ([String](/reference/data-types)) — Short name of a row policy. Names of row policies are compound, for example: myfilter ON mydb.mytable. Here 'myfilter ON mydb.mytable' is the name of the row policy, 'myfilter' is it's short name.
* `database` ([String](/reference/data-types)) — Database name.
* `table` ([String](/reference/data-types)) — Table name. Empty if policy for database.
* `id` ([UUID](/reference/data-types)) — Row policy ID.
* `storage` ([String](/reference/data-types)) — Name of the directory where the row policy is stored.
* `select_filter` ([Nullable(String)](/reference/data-types)) — Expression which is used for filtering in SELECT queries.
* `is_restrictive` ([UInt8](/reference/data-types)) — Shows whether the row policy restricts access to rows. Value: • 0 — The row policy is defined with `AS PERMISSIVE` clause, • 1 — The row policy is defined with AS RESTRICTIVE clause.
* `apply_to_all` ([UInt8](/reference/data-types)) — Shows that the row policies 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 row policies is applied.
* `apply_to_except` ([Array(String)](/reference/data-types)) — The row policies is applied to all roles and/or users excepting of the listed ones.

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

* [SHOW POLICIES](/reference/statements/show#show-policies)