Skip to content

docs: missing documentation for ROW ACCESS POLICY DDL commands (CREATE, DROP, DESC, ALTER, SHOW) #3301

@sundy-li

Description

@sundy-li

Missing Feature Documentation

Row Access Policy is fully implemented in Databend (enterprise feature) with complete interpreter support, but has no SQL reference documentation.

Implemented DDL Commands

  • CREATE ROW ACCESS POLICY [ IF NOT EXISTS ] <name> AS (<arg> <type> [, ...]) RETURNS BOOLEAN -> <body> [ COMMENT = '...' ]
  • DROP ROW ACCESS POLICY [ IF EXISTS ] <name>
  • DESC ROW ACCESS POLICY <name>
  • ALTER TABLE <table> ADD ROW ACCESS POLICY <policy>(<col> [, ...])
  • ALTER TABLE <table> DROP ROW ACCESS POLICY <policy>
  • ALTER TABLE <table> DROP ALL ROW ACCESS POLICIES

Source References

  • src/query/ast/src/ast/statements/row_access_policy.rs — AST definitions
  • src/query/service/src/interpreters/interpreter_row_access_policy_create.rs
  • src/query/service/src/interpreters/interpreter_row_access_policy_drop.rs
  • src/query/service/src/interpreters/interpreter_row_access_policy_desc.rs
  • src/query/service/src/interpreters/interpreter_table_row_access_add.rs
  • src/query/service/src/interpreters/interpreter_table_row_access_drop.rs
  • src/query/service/src/interpreters/interpreter_table_row_access_drop_all.rs
  • Requires: enable_experimental_row_access_policy = 1 setting

What's Missing

  • No DDL reference pages under docs/en/sql-reference/10-sql-commands/00-ddl/
  • No guide explaining row-level security with row access policies
  • No mention in the enterprise features list

Suggested Location

  • docs/en/sql-reference/10-sql-commands/00-ddl/ — new row-access-policy/ subdirectory with one page per command
  • Cross-reference from the enterprise features page

Metadata

Metadata

Assignees

No one assigned

    Labels

    documentationImprovements or additions to documentation

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions