pingcap / pingcap/tidb

Implement column level privilege on v8.5

Open
#61,706 1 comment 0 reactions 1 assignee Claimed by @CbcWestwolf View on GitHub
severity/minor sig/sql-infra type/bug type/feature-request
Dominant language
Go
Stars
40.5k
Forks
6.2k
PR merge metrics
PR metrics pending

Description

We need to implement column-level privilege on https://github.com/pingcap/tidb/tree/release-8.5-20250606-v8.5.2. For efficient review, 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 https://github.com/pingcap/tidb/pull/62024
2. [P2] Introduces column-priv view in `information_schema` https://github.com/pingcap/tidb/pull/61777

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

### Bug fix & test cases && enhancement:
* https://github.com/pingcap/tidb/pull/62241
* https://github.com/pingcap/tidb/pull/62443
* https://github.com/pingcap/tidb/pull/62693
* https://github.com/pingcap/tidb/pull/63175
* https://github.com/pingcap/tidb/pull/63728

Contributor guide

Open the contributing guide

Assessment

This issue has not been assessed yet.

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.