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
    No fields configured for issues without a type.

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions