Implement column level privilege on v8.5
- 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
Assessment
This issue has not been assessed yet.