ACCESS_HISTORY view (Account Usage and Organization Usage): Simplified records for policy creation (Pending)¶

ACCOUNT_USAGE.ACCESS_HISTORY 和 ORGANIZATION_USAGE.ACCESS_HISTORY 视图中的 object_modified_by_ddl 列包含与创建策略相对应的记录。此行为变更会影响与创建以下任何策略相对应的记录中所包含的内容：

• 聚合策略

• 联接策略

• 掩码策略

• 隐私策略

• 投影策略

• 行访问策略

• 存储生命周期策略

变更前:

记录中包含了创建策略时未指定的系统生成字段。例如，如果有人创建了行访问策略，则记录会包含带有默认值的详细类型信息：

{
  "policyReturnType": {
    "value": {
      "byteLength": null,
      "collation": null,
      "fixed": null,
      "length": null,
      "nullable": true,
      "precision": null,
      "scale": null,
      "template": null,
      "type": "BOOLEAN"
    }
  },
  "policySignature": {
    "value": {
      "arguments": [
        {
          "datatype": {
            "byteLength": 134217728,
            "collation": null,
            "fixed": false,
            "isMaxLength": true,
            "length": 134217728,
            "nullable": true,
            "precision": null,
            "scale": null,
            "template": null,
            "type": "TEXT"
          },
          "defaultVal": null,
          "hasDefaultValue": false,
          "identifier": "EMAIL",
          "parameterType": "NONE"
        }
      ]
    }
  }
}

Copy

变更后:

记录仅包含用户在创建策略时指定的信息。例如：

{
  "policyReturnType": {
    "value": {
      "type": "BOOLEAN"
    }
  },
  "policySignature": {
    "value": {
      "arguments": [
        {
          "datatype": {
            "type": "TEXT"
          },
          "identifier": "EMAIL"
        }
      ]
    }
  }
}

Copy

参考：2181