system.row_policies

Columns:
- (String) — Name of a row policy.

• short_name () — 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) — Database name.

• () — Name of the directory where the row policy is stored.

• select_filter (Nullable()) — Condition which is used to filter rows.

• 0 — The row policy is defined with AS PERMISSIVE clause.

• apply_to_all (UInt8) — Shows that the row policies set for all roles and/or users.

• apply_to_except ((String)) — The row policies is applied to all roles and/or users excepting of the listed ones.