tidb icon indicating copy to clipboard operation
tidb copied to clipboard

Implement column level privilege on v8.5

Open CbcWestwolf opened this issue 6 months ago • 0 comments

We split the huge https://github.com/pingcap/tidb/pull/61638 into 3 phases

Phase 1

  1. [P0] Adapt the GRANT and REVOKE for column privilege https://github.com/pingcap/tidb/pull/61678
  2. [P1] Adapt the MySQLPrivilege to support column privilege https://github.com/pingcap/tidb/pull/61677
  3. [P2] Adapt the show columns, show index and rename for column privilege https://github.com/pingcap/tidb/pull/61679

Phase 2

  1. [P0] Adapt the normal plan build process to collect column-level visit info https://github.com/pingcap/tidb/pull/61741

Phase 3

  1. [P0] Adapt the point-get plan build process
  2. [P2] Introduces column-priv view in information_schema https://github.com/pingcap/tidb/pull/61777

[P0] After the 3 phases, we also need to cherry-pick #58945 for improving performance: https://github.com/pingcap/tidb/pull/61719

CbcWestwolf avatar Jun 12 '25 09:06 CbcWestwolf