DESC ROW ACCESS POLICY

显示 TiDB Cloud Lake 中特定行访问策略的详细信息。

语法

DESC ROW ACCESS POLICY <policy_name>

也支持 DESCRIBE ROW ACCESS POLICY。

访问控制要求

满足以下任一条件即可：具有全局 APPLY ROW ACCESS POLICY 权限，或对特定行访问策略具有 APPLY/OWNERSHIP。

示例

SET enable_experimental_row_access_policy = 1;

CREATE ROW ACCESS POLICY rap_engineering
AS (dept STRING)
RETURNS BOOLEAN ->
  CASE
    WHEN current_role() = 'admin' THEN true
    WHEN dept = 'Engineering' THEN true
    ELSE false
  END
  COMMENT = 'show engineering rows';

DESC ROW ACCESS POLICY rap_engineering;

Name            | Created On                  | Signature     | Return Type | Body                                                       | Comment
----------------+-----------------------------+---------------+-------------+------------------------------------------------------------+----------------------
rap_engineering | 2026-05-15 08:42:10.949 UTC | (dept STRING) | BOOLEAN     | CASE WHEN current_role() = 'admin' THEN true WHEN...       | show engineering rows